(SQL) SELECT: Reading Data

(Substantially borrowed from W3Schools)

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

Example

Return data from the Customers table:

SELECT CustomerName, City FROM Customers;

If you want to return all columns, without specifying every column name, you can use the SELECT * syntax:

SELECT * FROM Customers;

SELECT is often used with a WHERE clause, as in:

SELECT * FROM Customers
WHERE CustomerId <= 19;