SQL SELECT

Internal

• SQL
• SQL WHERE

Overview

Upon execution, an SQL query returns a result set.

Query execution. SQL optimizer. Subqueries.

SELECT FROM WHERE GROUP BY HAVING ORDER BY 

Select all (possibly across multiple tables) then filter and discard with where.

Example

SELECT id, name FROM person WHERE id = ;

Clauses

FROM

FROM permanent|derived|temporary|virtual(view)

Table alias.

Querying Multiple Tables

Querying Multiple Tables

WHERE

The WHERE Clause

GROUP BY ... HAVING

(make sure I understand thoroughly and link)