SELECT statement is used to retrieve data/records from one or more tables in SQL Database
1SELECT * FROM table_name;
2
3SELECT column1, column2, ... FROM table_name;
4
5SELECT expressions
6FROM tables
7[WHERE conditions]
8[ORDER BY expression [ ASC | DESC ]];
Sample Database
| Id |
FullName |
Title |
Department |
Manager |
| 1 |
Eric Brown |
Software Engineer |
IT |
Frank Martin |
| 2 |
Brandon Hart |
DevOps Engineer |
IT |
Justin Martin |
| 3 |
Connor Langdon |
Software Engineer |
IT |
Lucas Scott |
| 4 |
James Murray |
Test Automation Engineer |
IT |
Frank Martin |
| 5 |
Leonard Smith |
Software Engineer |
IT |
Frank Roberts |
Examples / Outputs
1-- get engineer name and title
2SELECT FullName, Title FROM Engineer;
| FullName |
Title |
| Eric Brown |
Software Engineer |
| Brandon Hart |
DevOps Engineer |
| Connor Langdon |
Software Engineer |
| James Murray |
Test Automation |
| Leonard Smith |
Software Engineer |
1-- get Manager Frank Martin's team
2SELECT Id, FullName
3FROM Engineer
4WHERE Manager = 'Frank Martin'
5ORDER BY FullName ASC;
| Id |
FullName |
| 1 |
Eric Brown |
| 4 |
James Murray |