Collections:
DENSE_RANK() - Density Rank of Sorted Values
How to calculate the density rank of the sorting field expression in the current result set window using the DENSE_RANK() function?
✍: FYIcenter.com
DENSE_RANK() is a MySQL built-in window function that calculates the density rank of the sorting field expression in the current result set window. For example:
SELECT help_topic_id, help_category_id, DENSE_RANK() OVER w FROM mysql.help_topic WINDOW w AS (ORDER BY help_category_id); -- +---------------+------------------+---------------------+ -- | help_topic_id | help_category_id | DENSE_RANK() OVER w | -- +---------------+------------------+---------------------+ -- | 0 | 1 | 1 | -- | 1 | 1 | 1 | -- | 2 | 2 | 2 | -- | 6 | 2 | 2 | -- | 7 | 2 | 2 | -- | 8 | 2 | 2 | -- | 9 | 2 | 2 | -- ... -- +---------------+------------------+---------------------+
Reference information of the DENSE_RANK() function:
DENSE_RANK(): val Returns the density rank of the sorting field expression in the current result set window. Arguments, return value and availability: val: Return value. The density rank of the sorting field. Available since MySQL 8.
Related MySQL functions:
⇒ FIRST_VALUE() - First Value of Result Set Window
⇐ CUME_DIST() - Cumulative Distribution of Sorted Values
2023-12-19, 237🔥, 0💬
Popular Posts:
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...