What is the function of rank function?

The function of the rank function is to rank the data; the rank function is one of the basic functions of Excel. It can return the ranking of the specified field value in the result set partition. The ranking of the specified field value is before the relevant row. The ranking is increased by one, and the syntax is "RANK(number,ref,[order])".

The operating environment of this tutorial: Windows 10 system, Excel2022 version, DELL G3 computer.

What is the function of rank function

Rank function is one of the basic functions of Excel. Its function is to rank data.

The syntax structure is: RANK(number,ref,[order])

The number in the parameter after the function name is The value or cell name that needs to be ranked (the cell must be a number), ref is the reference value area for ranking, and order is 0 and 1. By default, there is no need to enter it. What you get is the ranking from large to small. If you want To find the last number, please use 1 as the value of order.

Rank is a T_sql function. The rank() function returns the ranking of the value of the specified field in the result set partition. The ranking of the value of the specified field is the ranking before the relevant row plus one.

The syntax is analyzed as follows:

RANK() OVER([<partiton_by_clause>]<order by clause>)

partition_by_clause divides the result set generated by the from clause into partitions applied to the RANK function.

Order_by_clause determines the order used when applying RANK values ​​to rows in a partition.

The following uses a score table as an example,

table structure

s_score（s_class(班级)，s_id（学号），s_score（分数））

SQL statement1:

Select rank() over(order by s_score desc) as 名次,s_class,s_id,s_score from s_score

More For related knowledge, please visit the FAQ column!

The above is the detailed content of What is the function of rank function?. For more information, please follow other related articles on the PHP Chinese website!