ROW_NUMBER for Pagination
Medium
window-functions
Amazon
Uber
Airbnb
Write a query using ROW_NUMBER() to assign a row number to each product ordered by price descending. Return row_num, name, and price.
Expected Output: Products numbered by price rank.
Tables
Hints (2 available)
SQL Editor
Output
Click "Run" to see results...