Shulou(Shulou.com)06/01 Report--

This article is about how to use the DENSE_RANK function in SQL. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

DENSE_RANK

The function of the dense_rank function is similar to that of the rank function. The dense_rank function is continuous when generating the sequence number, while the sequence number generated by the rank function may not be contiguous. When the same ranking occurs in the dense_rank function, the same ranking number will not be skipped, and the rank value immediately follows the previous rank value. Within each group, rank () is the jump sort, followed by the fourth place when there are two first places, and dense_rank () is the sequential sort, and the second place is still followed when there are two first places. Change the above Sql statement to the dense_rank function.

Select DENSE_RANK () OVER (order by [UserId]) as den_rank,* from [Order]

The query results are shown in the following figure:

The first and second records in the figure have the same user Id, so their sequence numbers are the same. The sequence number of the third record is immediately followed by the sequence number of the previous one, so it is 2 instead of 3, and so on.

Thank you for reading! This is the end of the article on "how to use the DENSE_RANK function in SQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.