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 normalization means?

968

Which certification is best for sql?

981

Explain cursor types?

1018

what is table? : Sql dba

1057

Explain what is a database?

1081

What is a field in a database?

1062

What are few of the schema objects that are created using PL/SQL?

1028

How is indexing done in search engines?

980

How can I tell if sql is running?

1062

What are the parameter modes supported by pl/sql?

1100

What are triggers in sql?

1014

What do you mean by stored procedures? How do we use it?

993

How long will it take to learn pl sql?

933

What is sql analyzer?

1008

What are the different operators available in sql?

1000