top of page



NTH_VALUE(expr, N) [from_first_last] [null_treatment] over_clause

Returns the value of expr from the N-th row of the window frame. If
there is no such row, the return value is NULL.

N must be a literal positive integer.

from_first_last is part of the SQL standard, but the MySQL
implementation permits only FROM FIRST (which is also the default).
This means that calculations begin at the first row of the window. FROM
LAST is parsed, but produces an error. To obtain the same effect as
FROM LAST (begin calculations at the last row of the window), use ORDER
BY to sort in reverse order.

over_clause is as described in
null_treatment is as described in the section introduction.

For an example, see the FIRST_VALUE() function description.



bottom of page