Select ename, eno, sal, rownum from (select ename, eno, sal from emp order

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

Question Posted / akshay

Answer Posted / akshay

Select ename, eno, sal, rownum
from (select ename, eno, sal from emp order by sal desc)
where rownum = 2;

Is This Answer Correct ?

7 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What does 0 mean in sql?

914

What is a constraint? Tell me about its various levels.

1085

What are different sql data types?

958

What is minus?

941

How long it takes to learn pl sql?

952

What is the best partition size for windows 10?

947

What is the maximum rows in csv?

860

Why we use joins in sql?

926

Whis is not false in primary key?

1406

How to combine two stored procedures in sql?

1124

How to rename a table?

959

What is indexing oracle sql?

1027

Is left join same as inner join?

1023

Can we insert data into view?

851

What does subquery mean in sql?

993