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
7344 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

What is the simplest tool to run commands on oracle servers?

974

How to get execution path reports on query statements?

949

What is a proxy object?

1026

What is an oracle database table?

973

What is the usage of synonyms?

1092

Why is oracle used?

905

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

937

How to define and use table alias names in oracle?

900

How to select some columns from a table in oracle?

1027

Explain the use of rows option in exp command.

1048

Which is better Oracle or MS SQL? Why?

6302

How to define a record variable to store a table row?

1029

What is a static data dictionary in oracle?

1053

What is meant by a deadlock situation?

1071

How to select some rows from a table in oracle?

1029