SQL SELECT Keyword

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:

SELECT CustomerName, City FROM Customers;

The following SQL statement selects all the columns from the "Customers" table:

SELECT * FROM Customers;