NTH_VALUE
Syntax
NTH_VALUE (expr[, num_row]) OVER ( [ PARTITION BY partition_expression ] [ ORDER BY order_list ] )
Contents
Description
The NTH_VALUE
function returns the value evaluated at row number num_row
of the window frame, starting from 1, or NULL if the row does not exist.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.