Browse Teach Curate

SQL SELECT Statement

SELECT declares which columns to return FROM which tables, with logical evaluation order FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY. It states what result is wanted, never how to compute it.

jeremy Video

The SELECT Statement in SQL

The SELECT statement is the fundamental SQL data query mechanism used to retrieve specified data from a database table, following the general syntax of naming one or more columns to return from a nam…