Collections:
NTH_VALUE() - N-th Value of Result Set Window
How to obtain the n-th value of a field expression in the current result set window using the NTH_VALUE() function?
✍: FYIcenter.com
NTH_VALUE(exp, n) is a MySQL built-in window function that returns the n-th value of a field expression in the current result set window. For example:
SELECT help_topic_id AS tip, help_category_id AS cid, name, NTH_VALUE(name, 2) OVER w FROM mysql.help_topic WINDOW w AS (PARTITION BY help_category_id); -- +-----+-----+----------------+---------------------------+ -- | tip | cid | name | NTH_VALUE(name, 2) OVER w | -- +-----+-----+----------------+---------------------------+ -- | 0 | 1 | HELP_DATE | HELP_VERSION | -- | 1 | 1 | HELP_VERSION | HELP_VERSION | -- | 2 | 2 | AUTO_INCREMENT | BIT | -- | 6 | 2 | BIT | BIT | -- | 7 | 2 | TINYINT | BIT | -- | 8 | 2 | BOOLEAN | BIT | -- | 9 | 2 | SMALLINT | BIT | -- ... -- +-----+-----+----------------+---------------------------+
Reference information of the NTH_VALUE() function:
NTH_VALUE(exp, n): val Returns the n-th value of a field expression in the current result set window. Arguments, return value and availability: exp: Required. The field expression to be evaluated. n: Required. The position of row in the current window. val: Return value. The n-th value of exp in the current window. Available since MySQL 8.
Related MySQL functions:
⇒ NTILE() - Dividing Window into N Tiles
⇐ LEAD() - N-Row after Current Row within Window
2023-12-19, 241🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...