| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
| Question: minvalue.sql Select the Nth lowest value from a table
Answer:
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 |
| August 08, 2006 12:38:51 |
#1 |
| Rama Krishna,Yerra |
Member Since: Visitor Total Comments: N/A |
RE: minvalue.sql Select the Nth lowest value from a ta...
|
1)By Using Rownum we can do the same mechanisam.. Select rownum,empno,ename,sal from(select rownum,empno,ename,sal from emp order by sal) having rownum=&n; 2) select empno,sal from emp e where &n>(select min(sal) from emp where sa l<e.sal); Thanks&Regds Ramki,TCS,DP HYd |
| |
Back To Question | |
