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
7264 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 rebuild an index in oracle?

968

Explain a data segment?

1011

Explain oracle’s system global area (sga).

1073

What happens if you lost a data file?

977

What are the various oracle database objects?

1090

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1617

Can we connect to ORACLE db using Windows Authentication?

1178

How to use null as conditions in oracle?

1000

What is oracle latest version?

1037

What is the max number of columns in an oracle table?

928

Give the various exception types.

939

How to speed up webrick?

1004

What is open database communication (odbc) in oracle?

947

How a tablespace is related to data files?

1057

What is sharded cluster?

924