SELECT

Also known as · SELECT Clauses

Chooses which columns or expressions appear in the output.

sql
SELECT title, rental_rate
FROM film

When to use

Starts every query in the course, for example PS 03 and PS 04. It is evaluated after WHERE, GROUP BY and HAVING, so an alias defined in SELECT cannot be used in WHERE.

See PS 03.

Appears in

No references yet.