SQL SELECT Statement

The SELECT statement is used to select data from a database.

The result is stored in a result table, called the result-set.

SQL SELECT Syntax

SELECT column_name (s)  FROM table_name    --To select specific columns only from a table

SELECT * FROM table_name    --To list the table