Write a query to find second highest salary of an employee.

Categories >> Software >> Testing >> Automation Testing >> Automation Testing AllOther
Suggest New Category

Question Posted / ravi

72 Answers
129011 Views
ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Write a query to find second highest salary of an employee. ..

Answer / rajkumar mandala

select sal from
(select sal,(row_number() over (order by sal)) N from emp ) y where N= {value}

Replace {value} value with required highest value.
ie, 2 for 2nd highest

Is This Answer Correct ?

7 Yes

3 No

Write a query to find second highest salary of an employee. ..

Answer / aj

select * from emp A where 1=(select count(*) from emp B
where A.SALARY < B.SALARY)

Is This Answer Correct ?

12 Yes

9 No

Write a query to find second highest salary of an employee. ..

Answer / girase hitendrasing a.

select * from Employees where Salary in (select top 1
salary from (select distinct top 2 salary from employees
order by salary desc) order by salary asc)

Is This Answer Correct ?

5 Yes

2 No

Write a query to find second highest salary of an employee. ..

Answer / bhaskar reddy thamma

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

Is This Answer Correct ?

2 Yes

0 No

Write a query to find second highest salary of an employee. ..

Answer / n.tejaswi

Select Empname
from emp LIMIT 2
orderby empsal;

Is This Answer Correct ?

2 Yes

1 No

Write a query to find second highest salary of an employee. ..

Answer / khurram

The Simplest, easy, Understandable solution is

select max(sal) from emp where
sal not in
(select distinct Top 1 sal from emp order by sal desc)

Go Check Out for yourself
[replace "top 1" by "top 2" to get 3rd highest sal]
[replace "top 1" by "top 3" to get 4th highest sal] so on..

Is This Answer Correct ?

2 Yes

1 No

Write a query to find second highest salary of an employee. ..

Answer / jyo

select salary from employee where salary>1st

Is This Answer Correct ?

3 Yes

2 No

Write a query to find second highest salary of an employee. ..

Answer / ujwlala

select max(salary) from employee where salary<>(select
max(salary) from emp)