rem ----------------------------------------------------------------------- rem Filename: minvalue.sql rem Purpose: Select the Nth lowest value from a table rem Date: 18-Apr-2001 rem Author: Deepak Rai, SSE, Satyam Computer Services Ltd. India rem ----------------------------------------------------------------------- select level, min('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 lowest salary: -- -- select level, min(sal) from emp -- where level=2 -- connect by prior sal < sal -- group by level --