# 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