SQL Select Statement

SQL Select Statement used to select the data from database.

• • It is used to retrieve records from one or more tables in your SQL database
  • We can select all columns from a table or can select only particular column using select statement in SQL
  • The records retrieved are known as a result set.

Syntax:

SELECT expressions
FROM tables
[WHERE conditions]
[ORDER BY expression [ ASC | DESC ]];

Example:

SELECT Statement for Employee Table.

Recommended Articles:

• • SQL-Update Statement
  • SQL-Delete Statement
  • SQL Constraints
  • SQL-Not Null Constraint
  • SQL-Unique Constraint