Select SQL

Perintah Select digunakan untuk menampilkan data suatu database, syntax sbb :

SELECT column_name,column_name
FROM table_name;

dan

SELECT * FROM table_name;

Contoh :

SELECT DeptID, Name  FROM  [HR].[Department];
DeptID          Name
1                  Sales

2                  Accounting
3                  Human Resource

SELECT * FROM [HR].[Department]; 
DeptID       Name                       Address
1                  Sales                       Jakarta
2                  Accounting             Surabaya
3                  Human Resource    Jakarta