Reading data is at the core of SQL. A query specifies which table to read, which columns to return, which rows to keep, and how to order the result.
This chapter introduces SELECT, FROM, WHERE, operators, ORDER BY, row limits, DISTINCT, and aliases. Examples use broadly supported SQL unless a dialect is identified; details such as row-limit syntax and integer division vary between database systems.