select a.last_name,a.salary from employees a where 3=(select count(*) from

Write query to fetch second maximum salary from employee table.

Question Posted / abhishekjaiswal

4 Answers
7440 Views
Bravura Solutions, HCL, I also Faced
E-Mail Answers

select a.last_name,a.salary from employees a where 3=(select count(*) from employees b where b.salary>a.salary) order by a.salary desc.
<<<<<<<<<[N-1]>>>>>>>>>>

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to generate query output in html format?

1111

What is oracle open database communication (odbc)?

1022

How would you change old and new values in an insert, delete and update triggers?

1014

how do u setup a replication site?

1977

Hi Can any one tell me what are the API's used in requisition import.

1917

What happens in oracle commit?

1020

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1103

How does Oracle guarantee data integrity of data changes?

2382

How to use "for" statements in oracle?

1072

What is ASM (Automatic Storage Management) in Oracle?

1188

How to use "if" statements on multiple conditions?

1166

Explain a data segment?

1062

what is meant by magic query

2177

Explain compound trigger in oracle?

1028

What are a cluster and non-cluster index?

1016