Write query to fetch second maximum salary from employee table.

Question Posted / nitin

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

Answers were Sorted based on User's Feedback

Write query to fetch second maximum salary from employee table...

Answer / ritesh

select max(salary) from emptable where salary < (select max(salary) from emptable);

Is This Answer Correct ?

8 Yes

0 No

Write query to fetch second maximum salary from employee table...

Answer / vijayalakshmi

select top 1 Coumn_Name from (select top 2 Coumn_Name from Table_name order by Coumn_Name desc) b order by Coumn_Name

Is This Answer Correct ?

4 Yes

0 No

Write query to fetch second maximum salary from employee table...

Answer / abhishekjaiswal

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

Write query to fetch second maximum salary from employee table...

Answer / santosh kumar

select * from(select rownum r,ename,sal from(select * from emp order by sal desc))where r=2;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer