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 the minimum client footprint required to connect c# to an oracle database?

1016

What are data pump export and import modes?

1014

What is oracle in java?

906

What is the difference between hot backup and cold backup in oracle?

951

What is the difference between sharding and replication?

952

What is transport network substrate (tns) in oracle?

989

How many types of database triggers exist?

1063

Why do you create or replace procedures rather that drop and recreate.

943

What suggestions do you have to reduce the network traffic?

896

How to use subqueries with the in operator using oracle?

1029

How to assign a table row to a record variable?

963

How does the on-delete-cascade statement work?

1058

Explain integrity constraint?

1103

How to execute a stored procedure in oracle?

1027

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1874