Analytical Functions in SQL. Part 3

Named windows may be thought of as an alias for the condition within OVER clause of SQL code. This makes the code readable, user friendly and well as reusable.

To illustrate, I use the below data set that contains columns — educational courses, category, quantity sold .

Where does a Named window fit in, within the SQL

A Named window falls between the HAVING and ORDER BY clause of SQL statement

Use a Named Window with RANK, DENSE_RANK & ROW_NUMBER

Use a Named Window with PARTITION_BY clause