SELECT

The SQL statement that reads data: it names the columns you want in the answer and, with FROM, the tables they come from.

In more detail

A SELECT does not change any data; it returns a result set of rows. Its clauses run in a logical order that differs from the order you write them: FROM and joins first, then WHERE, GROUP BY, HAVING, the select list, and ORDER BY and LIMIT last.

Examples

Detection logic written in SQL is mostly SELECT queries with WHERE conditions and joins.
SELECT name, city FROM customers;

Related terms

Taught in

References

Certification courses