select * from(select rownum r,ename,sal from(select * from emp order by sal

Write query to fetch second maximum salary from employee table.

Question Posted / santosh kumar

Answer Posted / santosh kumar

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is oracle database 10g express edition?

1114

How to rename an index in oracle?

1108

What is oracle in java?

959

What happens to the current transaction if the session is killed?

983

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2289

Explain the use of record length option in exp command.

1060

How to unlock the sample user account in oracle?

1005

How do I limit the number of oracle database connections generated by weblogic server?

1061

How to update values in a table in oracle?

1010

Explain the use of compress option in exp command.

1016

What happens to the data files if a tablespace is dropped?

1054

Explain the use of analyse option in exp command.

1122

Explain joins in oracle?

1028

What are the data types in oracle?

1033

How do I find my oracle client driver version?

1035