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