Syntax\n------\n\nNTH_VALUE (expr[, num_row]) OVER ( \n  [ PARTITION BY partition_expression ] \n  [ ORDER BY order_list ]\n)\n\nDescription\n-----------\n\nThe 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.\n\nURL: https://mariadb.com/docs/server/reference/sql-functions/special-functions/window-functions/nth_value