NTH_VALUE

The NTH_VALUE function returns the value located in the selected column of a specified row of a segment. While the NTH_VALUE function is identical to the FIRST_VALUE and LAST_VALUE functions, it requires you to add a literal and whole int type n value representing the row number containing the value that you want. If you select an n value larger than the number of rows in the table, the NTH_VALUE function returns NULL.

Syntax

The following shows the correct syntax for the NTH_VALUE function.

NTH_VALUE(Selected_Column, n) OVER (...)

Examples

The following example shows the syntax for a table named superstore used for tracking item sales in thousands:

CREATE TABLE superstore
(
   "Section" varchar(40),
   "Product_Name" varchar(40),
   "Sales_In_K" int,
    );

The following example shows the output of the syntax above:

Section

Product_Name

Sales_In_K

bed

pillow_case

17

bath

rubber_duck

22

beyond

curtain

15

bed

side_table

8

bath

shampoo

9

bed

blanket

7

bath

bath_bomb

13

bath

conditioner

17

beyond

lamp

7

bath

soap

13

beyond

rug

12

bed

pillow

17