Only this week, get the SQL Complete Track of 9 courses in a special prize of $330$89!
Introduction
Quick Refresher
PARTITION BY ORDER BY with Ranking
PARTITION BY ORDER BY with Window Frames
Using PARTITION BY ORDER BY with Analytical Functions
Summary and Review
19. Summary

## Instruction

Good for you - you've learned how to use PARTITION BY with ORDER BY!

Now you know that you can use PARTITION BY ORDER BY to create rankings and do row-level analytics independently for each partition in a single T-SQL query.

Are you ready for a short quiz?

## Exercise

Click to continue.