Ordering Expressions

When we want to order expressions we need to refer to the expression by its alias or its position.

Example:

SELECT price * .9 disc, author, title

FROM books

ORDER BY disc, title

or

ODER BY 1, title

Previous slide

Next slide

Back to first slide

View graphic version