sql Select the Nth Highest value from a table?
select level, max(‘col_name’) from my_table where level = ‘&n’ connect by prior (‘col_name’) > ‘col_name’) group by level; Example: Given a table called emp with the following columns: — id number — name varchar2(20) — sal number — — For the second highest salary: — select level, max(sal) from emp — where level=2 — connect by prior sal > sal — group by level
