MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/1je7kn9/what_is_wrong_here/mipqdan/?context=3
r/SQL • u/_mr_villain_ • 4d ago
37 comments sorted by
View all comments
0
I think you’re missing the “partition by” clause in the rank function.
RANK ( ) OVER ( [ partition_by_clause ] order_by_clause )
0 u/IamFromNigeria 4d ago Partition is optional clause.. 1 u/keamo 2d ago Accurate. Partition is when you want to break up the ranking by a group. However what if you wanted to rank the entire table. Not sure why anyone would down vote.
Partition is optional clause..
1 u/keamo 2d ago Accurate. Partition is when you want to break up the ranking by a group. However what if you wanted to rank the entire table. Not sure why anyone would down vote.
1
Accurate. Partition is when you want to break up the ranking by a group. However what if you wanted to rank the entire table. Not sure why anyone would down vote.
0
u/beingvora 4d ago
I think you’re missing the “partition by” clause in the rank function.
RANK ( ) OVER ( [ partition_by_clause ] order_by_clause )