SELECT STATEMENT

The “Select” statement is used to select data from database.

Syntax:

Extract data from all columns:

Select * from <Table name>

Example:

Select * from Sample_Table

Result set:

Extract data from required columns:

Select Column 1, Column 2, …., Column N from <Table name>

Example:

Select ID,Name from Sample_Table

Result set: