Collections:
RANK() - Vale Rank of Sorted Values
How to calculate the value rank of the sorting field expression in the current result set window using the RANK() function?
✍: FYIcenter.com
RANK(n) is a MySQL built-in window function that calculates the value rank of the sorting field expression in the current result set window. For example:
SELECT help_topic_id AS tic, help_category_id AS cid, RANK() OVER w, DENSE_RANK() OVER w FROM mysql.help_topic WINDOW w AS (ORDER BY help_category_id); -- +-----+-----+---------------+---------------------+ -- | tic | cid | RANK() OVER w | DENSE_RANK() OVER w | -- +-----+-----+---------------+---------------------+ -- | 0 | 1 | 1 | 1 | -- | 1 | 1 | 1 | 1 | -- | 2 | 2 | 3 | 2 | -- | 6 | 2 | 3 | 2 | -- | 7 | 2 | 3 | 2 | -- | 8 | 2 | 3 | 2 | -- | 9 | 2 | 3 | 2 | -- | 10 | 2 | 3 | 2 | -- ... -- +-----+-----+---------------+---------------------+
Reference information of the RANK() function:
RANK(): val Calculates the value rank of the sorting field expression in the current result set window. Arguments, return value and availability: val: Return value. The value of the sorting field. Available since MySQL 8.
Related MySQL functions:
⇒ ROW_NUMBER() - Row Position in Result Set Window
⇐ PERCENT_RANK() - Rank Percentage of Sorted Values
2023-12-19, 223🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...