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, 231🔥, 0💬
Popular Posts:
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...