Department
1 post1 contributor
+ FollowBe the first to follow this
Write about itArticles about Department
Rank and Dense_Rank Function in SQL Server
RANK and DENSE_RANK functions in SQL Server assign sequential numbers to rows based on ordering. RANK skips numbers for ties, while DENSE_RANK does not. Both can partition results using the PARTITION BY clause. These functions are commonly used to rank rows, find highest salaries, and more.
