Question

Employees and salaries: Alice=9000, Bob=7000, Carol=9500, Dave=7000. What rank does Dave receive from the following query? SELECT name, salary, RANK() OVER (ORDER BY salary DES

Q: Answer-Employees and salaries: Alice=9000, Bob=7000, Carol=9500, Dave=7000. What rank does Dave receive fro...

Sorting by salary in descending order Carol 9500 is ranked 1st. Alice 9000 is ranked 2nd. Bob and Dave are tied at 7000, and RANK assigns the same rank to tied values both receive rank 3rd. Note RANK would then skip to rank 5 for the next distinct lower value, since two rows already occupy positions 3 and 4 but since there is no row after the tie here, this gap is simply not used. This gap-leaving behaviour is what distinguishes RANK from DENSERANK, which would not skip a rank number after a tie.