SELECT SQL Keyword


Overview

The SELECT SQL keyword can be used in a query to tell the server what to retrieve from the database. It may be followed by * (retrieves every column from the table), a column name ('username' for exemple), or by a function (COUNT(username) for exemple).

Example

SQL
SELECT * FROM users;

Here, the SELECT keyword tells the server to fetch all data from the 'users' table.

See also

FROM
WHERE