1 // -----------------------------------------------------------------------
2 // Filename: minvalue.sql
3 // Purpose: Select the Nth lowest value from a table
5 // Author: Deepak Rai, SSE, Satyam Computer Services Ltd. India
6 // -----------------------------------------------------------------------
11 -- Given a table called emp with the following columns:
16 -- For the second lowest salary:
18 -- select level, min(sal) from emp
20 -- connect by prior sal < sal