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 an oracle recycle bin?

1012

How can I create database in oracle?

1030

What is key preserved table?

1026

What are the various types of snapshots ?

1032

What are the oracle differences between nvl and coalesce

1150

What is a synonym? What are its various types?

1111

Where do you use decode and case statements?

1000

How a database is related to tablespaces?

1039

How do I find the database name in oracle?

1042

How to create a new user account in oracle?

1022

How to use in conditions in oracle?

1058

Explain the use of rows option in imp command.

1088

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2188

How do I recompile a procedure in oracle?

966

How to rename a column in an existing table?

1037