SQL SELECT

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