Analytical Windows

Understand the idea

In this lesson, explore analytical windows. Study the SQL example, run it in the lab when applicable, and consider how it relates to real database systems.

SELECT name,score, RANK() OVER(ORDER BY score DESC) AS rank FROM students;