Correlated Subqueries
Running totals
Correlated subqueries
Other examples of using window functions
Window functions
LAG and LEAD functions
Window functions
Combination of detailed and aggregated data
Getting summarizing values
CROSS APPLY / OUTER APPLY
New sql features
Exercise #8 (tips and solutions)
Tips and solutions
EXISTS predicate
Conventional set-theoretic operations and the SELECT statement
Exercise #(-2)
Database «Ships»
Exercise #15 (tips and solutions)
Tips and solutions
Correlated subqueries
Typical problems
Relational division
SELECT statement