Ordering
Question:
We would like to find the fattest cat. Order all our cats by weight. The two heaviest cats should both be 1st. The next heaviest should be 3rd.
Return: ranking, weight, name
Order by: ranking, name
Show Table
Cats:
| name | varchar |
| breed | varchar |
| weight | float |
| color | varchar |
| age | int |
Show Desired Output
Desired output:
| ranking | weight | name |
| 1 | 6.10 | Oscar |
| 1 | 6.10 | Smokey |
| 3 | 5.70 | Misty |
| 4 | 5.50 | Alfie |
| 5 | 5.40 | Millie |
| 6 | 5.10 | Puss |
| 7 | 5.00 | Felix |
| 8 | 4.90 | Smudge |
| 9 | 4.80 | Charlie |
| 10 | 4.50 | Ashes |
| 11 | 4.20 | Molly |
| 12 | 3.80 | Tigger |
Query Window:
Correct output but can you use 'rank'?
×
Good work!
rank() lets us index the ordered items. Unlike row_number() it allows duplicate numbers. next question
Show Answer
Answer:
select
rank() over (order by weight desc) as ranking,
weight, name
from cats
order by ranking, name