select empno,ename,sal from (select ename,empno,sal,dense

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

Question Posted / sohail

Answer Posted / sohail

select empno,ename,sal
from (select ename,empno,sal,dense_rank()
over(order by sal desc)topn
from emp)
where topn=2

Is This Answer Correct ?

69 Yes

46 No

Please Help Members By Posting Answers For Below Questions

Can we rollback delete command?

939

What is record type in pl sql?

941

does sql support programming? : Sql dba

994

What is the trigger in sql?

906

Can you join a table to itself?

1035

How can check sql version from command line?

1014

What are the operators used in select statements?

1003

What is field delimiter?

991

Which sql most popular?

939

What is 19 null in sql?

900

What pl/sql package consists of?

1033

What is a primary key sql?

995

What is the difference between alter trigger and drop trigger statements?

1044

What is oracle and pl sql?

1082

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1047