ORDER BY
Paging records
About window functions
ROW_NUMBER function
About ranking functions
Simple SELECT statement
SELECT statement
About ranking functions
New sql features
About window functions
New sql features
LAG and LEAD functions
About window functions
ORDER BY clause
About the use of the operator CASE
Exercise #10 (tips and solutions)
Tips & solutions