Cheat Sheet logoCheat Sheet Today
MySQL Aggregation and Window Functions Cheatsheet/Dense rank grouped totals

Rank categories by revenue without gaps.

Back to sheetBrowse commands
Sign in to save
Section: window functions

Dense rank grouped totals

sql
sql
SELECT
  category,
  revenue,
  DENSE_RANK() OVER (ORDER BY revenue DESC) AS revenue_rank
FROM category_revenue;
Explanation

Unlike `RANK`, `DENSE_RANK` does not skip numbers after ties.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing window functions
Assign row numbers within each user
Rank a user's orders by recency.
OpenIn sheetsqlsame section
Calculate a running total
Compute cumulative revenue by day.
OpenIn sheetsqlsame section
Compare to the previous row with LAG
Calculate day-over-day change.
OpenIn sheetsqlsame section
Count all rows
Return the total number of rows in a table.
OpenIn sheetsql
Group rows and count them
Count orders by status.
OpenIn sheetsql
Use SUM and AVG
Calculate totals and averages.
OpenIn sheetsql