The SELECT statement is used to retrieve the data from a database table in the form of result sets.
Syntax of SELECT to fetch all columns:
SELECT * FROM tableName;
Example:
SELECT * FROM EMPLOYEE; |
Output:
EMP_ID EMP_NAME AGE SALARY 1 Parbhjot 28 35000 5 Parmender 28 45000 2 Parmender 30 45000 3 Nidhi 28 48000 4 Parbhjot 29 46000 |
Syntax of SELECT to fetch specific columns:
SELECT column1, column2, columnN FROM tableName;
Example:
SELECT EMP_ID, EMP_NAME FROM EMPLOYEE; |
Output:
EMP_ID EMP_NAME 1 Parbhjot 5 Parmender 2 Parmender 3 Nidhi 4 Parbhjot |
Next Topic: SQL UNIQUE keyword with example.
Previous Topic: SQL UPDATE statement with example.