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 commit in trigger?

988

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1114

Explain ttitle and btitle.

1127

Can we write ddl statements in functions?

1128

Can primary key be changed?

915

Is sql considered coding?

1050

What are the different ddl commands in sql?

1182

What is cost in sql execution plan?

996

What do you understand by pl/sql cursors?

1097

What is difference between table and view?

1074

What is the syntax to add a record to a table?

1100

How long will it take to learn pl sql?

947

what is cross join? : Sql dba

1009

What is an exception in PL/SQL? What are the two types of exceptions?

1326

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1097