How to use the SQLServer RANK () ranking function

Today, I would like to share with you the relevant knowledge points about how to use the SQLServer RANK () ranking function. The content is detailed and the logic is clear. I believe most people still know too much about this knowledge, so share this article for your reference. I hope you can get something after reading this article.

The details are as follows:

-- example sub-table data SELECT * FROM test;-- Statistical score SELECT name,SUM (achievement) achievement FROM test GROUP BY name;-- ranking by statistical score SELECT RANK () OVER (ORDER BY SUM (achievement) desc), name,SUM (achievement) achievement FROM test GROUP BY name

The question-and-answer stored procedure uses:

USE [DB] GO / * Object: StoredProcedure [dbo]. [sp_TodayJoinUser] Script Date: 14:45:24 on 2021-1-26 * / SET ANSI_NULLS ONGO SET QUOTED_IDENTIFIER ONGO-- =-- Author: _ Hey_Jude-- Create date: 2021-01-26 muri-Description: get new users who post help / responses today-- = CREATE PROCEDURE [dbo]. [sp_TodayJoinUser] @ tableLevel int @ date varchar (30) ASDeclare @ Sql nvarchar (max) declare @ minTabId intdeclare @ maxTabId intdeclare @ maxf_id intdeclare @ helpTableName nvarchar (max) declare @ tableCount int BEGIN-the smallest f_id table set @ minTabId=0 set @ tableCount=@minTabId-the largest f_id table set @ maxf_id= (select MAX (F_ID) from [Table] where F_IsDelete=0) set @ maxTabId=@maxf_id/ @ tablelevel set @ helpTableName='SELECT UserID Max ([F_DateTime]) AS dt FROM [Table] GROUP BY UserID' while @ tableCount