Select
The SELECT command is used to select data from a database. The data returned is stored in a result table, called the result set.
The following SQL statement selects the "CustomerName" and "City" columns from the "Customers" table:
Example
SELECT CustomerName, City FROM Customers;The following SQL statement selects all the columns from the "Customers" table:
Example
SELECT * FROM Customers;