hardDSA

What is the difference between ROW_NUMBER, RANK, and DENSE_RANK?

Q: What is the difference between ROW_NUMBER, RANK, and DENSE_RANK?

All number rows within a window. **ROW_NUMBER** gives unique sequential numbers. **RANK** gives ties the same rank but leaves gaps (1,1,3). **DENSE_RANK** gives ties the same rank without gaps (1,1,2). Pick based on how you want ties handled.

740 views

Understand the problem

Explain ranking functions.

windowranking

Attempt it yourself

Sketch your approach before reading the solution — that's what interviews test.

Nudge consolestandby

Stuck? Beam a request up — the console returns a conceptual nudge that guides your logic without spoiling the implementation.

Study the solution

All number rows within a window. ROW_NUMBER gives unique sequential numbers. RANK gives ties the same rank but leaves gaps (1,1,3). DENSE_RANK gives ties the same rank without gaps (1,1,2). Pick based on how you want ties handled.

Solution ready — 2 min read

Classified // press E to declassify

Run the code

SQLRanking Functions Playground

Join the discussion

Discussion (0)

No responses yet. Be the first to share what you think.

Transmission complete // awaiting log

KEEP THE
STREAK ALIVE.

Dossier 60 of 70 decoded in the SQL track. One more won't hurt.

Back to track

Next up→

How do you pivot rows into columns?

Continue