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
7477 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 difference between truncate & delete command?

1189

What is a user role in oracle?

1133

how to join query for one source type is oracle another source type is sql server ?

2429

How to start instance with a minimal initialization parameter file?

1048

What are internal user account in oracle?

1012

Explain the importance of .pll extension in oracle?

1013

How do we display rows from the table without duplicates?

977

How oracle handles dead locks?

1072

What is system tablespace?

1103

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1945

What is blob data type in oracle?

1125

How to install oracle database 10g xe?

1024

How to view the data files in the current database?

1102

How to test null values?

1113

What are the execution control statements?

1071