Daxuyaniya Hilbijartina SQL

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.



Hevoksaziya SQL SELECT

SELECT vegotin ev hevoksaziya jêrîn heye:


SELECT column1, column2, ... FROM table_name;

Mînakên Daxuyaniya SQL SELECT

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 Stûnek BELA BIKE

Ji bo hilbijartina stûna 'Beşa' ji tabloya 'Karmend':


SELECT Department FROM Employees;

Karûabr:

+------------+ | Department | +------------+ | Finance | | IT
| | Marketing | | IT
| +------------+


Ji Pir Stûnan BELA BIKE

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
| +------------+------------+


SELECT * Daxuyanî

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
| +------------+-----------+----------+------------+


Fîlterkirina Encaman Bikaranîna BELA WH KU

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

| +------------+