maxvalue.sql Select the Nth Highest value from a table?
ORACLE Interview Questions and Answers (Part 4)
(Continued from previous question...)
589. maxvalue.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
(Continued on next question...)
Other Interview Questions
|