ROW_NUMBER: what order determines the rank?

Question

Accepted Answer

ROW_NUMBER() assigns a sequential integer to each row based on the ORDER BY inside OVER. Sorted by salary DESC: Alice (90000) = 1, Bob (80000) = 2, Carol (70000) = 3. Unlike GROUP BY, window functions do not collapse rows - every source row appears in the output.