SQL & PL/SQL

I was confused to wrote a query which will retrieve the maximum nth value

i did this , i imagined the values are in the column col_values and the table is numbers_table.

" select max(col_values) from numbers_table. "

is this not the correct way to identify a nth maximum value.