select rownum,empno,sal from (select rownum,empno,sal from emp order by s

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / priya

69 Answers
120074 Views
Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
E-Mail Answers

Answer Posted / priya

select rownum,empno,sal from (select
rownum,empno,sal from emp order by sal desc) group
by rownum,empno,sal having rownum=2;

This will clearly work.............

Is This Answer Correct ?

6 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is mdb stand for?

1058

Which software is used for pl sql programming?

1034

Does oracle use sql?

991

How many functions are there in sql?

1094

How do you break a loop in pl sql?

1101

How sql query is executed?

1187

How do I add a primary key to a table?

1082

What is a schema sql?

1224

What is #table in sql?

1181

Which command is used to call a stored procedure?

1050

Write a query to find the names of users that begin with "um" in sql?

1043

What is full join?

1019

What is db journal file?

1155

Are stored procedures compiled?

980

what is the syntax used for partition in tsql? : Transact sql

1060