SQL Ranking Functions: Part 1 The Over Clause

Overview of the SQL Ranking functions, focusing on the OVER clause, which must have an ORDER BY part, and might also have a PARTITION BY part.