ORDER BY

Paging records

Window functions

ROW_NUMBER function

Ranking functions

Simple SELECT statement

SELECT statement

Ranking functions

New sql features

LAG and LEAD functions

Window functions

Window functions

New sql features

ORDER BY clause

About the use of the operator CASE

Exercise #10 (tips and solutions)

Tips and solutions