SQL Reference Manual

SQL Keyword Reference

SELECT

Usage and examples of SQL SELECT keyword

The SELECT command is used to select data from a database. The returned data is stored in a result table, known as a result set.

　The following SQL statement selects the 'CustomerName' and 'City' columns from the 'Customer' table:

The following SQL statement selects all columns from the 'Customer (Customers)' table:

　SELECT　*　FROM Customers;

SQL Keyword Reference