SELECT
daxuyaniya di SQL de ji bo vegerandina daneyan ji tabloya databasê tê bikar anîn.
Em dikarin SELECT
bikar bînin daxuyanî da ku hûn ji stûn (an) an hemî stûnên diyarkirî bistînin.
SELECT
vegotin ev hevoksaziya jêrîn heye:
SELECT column1, column2, ... FROM table_name;
Bifikirin ku me daneyên jêrîn tabloyek bi navê 'Karmend' heye:
+------------+-----------+----------+------------+ | EmployeeID | FirstName | LastName | Department | +------------+-----------+----------+------------+ | 1
| Mark
| Otto
| Finance | | 2
| Jacob
| Thornton | IT
| | 3
| Su
| Bird
| Marketing | | 4
| Sam
| Burger | IT
| +------------+-----------+----------+------------+
Ji bo hilbijartina stûna 'Beşa' ji tabloya 'Karmend':
SELECT Department FROM Employees;
Karûabr:
+------------+ | Department | +------------+ | Finance | | IT
| | Marketing | | IT
| +------------+
Ji bo hilbijartina stûnên 'Beşa' û 'EmployeeID' ji tabloya 'Karmendan':
SELECT EmployeeID, Department FROM Employees;
Karûabr:
+------------+------------+ | EmployeeID | Department | +------------+------------+ | 1
| Finance | | 2
| IT
| | 3
| Marketing | | 4
| IT
| +------------+------------+
Ji bo hilbijartina hemî stûnan ji maseya 'Karmend':
SELECT * FROM Employees;
Karûabr:
+------------+-----------+----------+------------+ | EmployeeID | FirstName | LastName | Department | +------------+-----------+----------+------------+ | 1
| Mark
| Otto
| Finance | | 2
| Jacob
| Thornton | IT
| | 3
| Su
| Bird
| Marketing | | 4
| Sam
| Burger | IT
| +------------+-----------+----------+------------+
Em dikarin encaman ji SELECT
| parzûn bikin pirsîn bi karanîna WHERE
şert.
Ji bo nimûne, ku hemî karmendên di 'Beşa IT' de bikar bînin hilbijêrin:
SELECT * FROM Employees WHERE Department='IT'
Karûabr:
+------------+-----------+----------+------------+ | EmployeeID | FirstName | LastName | Department | +------------+-----------+----------+------------+ | 2
| Jacob
| Thornton | IT
| | 4
| Sam
| Burger | IT
| +------------+-----------+----------+------------+
Bi heman awayî, ji bo hilbijartina hemî Nasnameyên karmendên ku di 'Beşa IT' de ne ku em bikar tînin:
SELECT EmployeeID FROM Employees WHERE Department='IT'
Karûabr:
+------------+ | EmployeeID | +------------+ | 2
| | 4
| +------------+