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
7629 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 view is different from a table?

1089

How to write a query with a left outer join in oracle?

1126

interview questions with answer for cts

2638

Can we create trigger on materialized view in oracle?

1045

Oracle

2427

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2265

Respected sir, Please send me technical questions related to oracle apps..

1867

How to check the oracle tns settings?

1089

Explain about the analyze command in oracle?

1113

Explain a synonym?

1088

How to manage transaction isolation level?

1057

List the various oracle database objects?

1111

State and explain the different types of data models?

995

Name the various constraints used in oracle?

1080

How to drop a stored procedure in oracle?

1106