Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

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)

Is This Answer Correct ?    2 Yes 1 No

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

Answer / satish

select e1.* from emp e1 where 1=(select count(distinct
e2.sal) from emp e2 where e2.sal>e1.sal)

Is This Answer Correct ?    2 Yes 1 No

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

Answer / ashutosh singh

select distinct(a.Sal) from emp a where &n=(select
count(distinct(b.Sal)) from emp b where b.Sal<a.Sal)

Is This Answer Correct ?    2 Yes 1 No

Post New Answer



More Automation Testing AllOther Interview Questions

Elaborate the scripting standard while executing testing

0 Answers  


What testing activities you may want to automate in a project?

1 Answers  


Suppose we r running a test which have 7 to 8 steps for different functionallity of and object..and suppose upto 4 step test passes but after 5th step test fails. what u will do in this condition will u start the test again or will u consider that rest steps will be working fine.

1 Answers   Logica CMG,


what is the difference between keyword driven frame work and data driven frame work.

0 Answers   TCS,


all clients are using at once if any problem raise?

0 Answers   Mind Tree,






Is automation testing a complete replacement for manual software testing?

0 Answers  


In Selenium how a test suit is run and report is generated.

0 Answers  


When is automation testing useful?

0 Answers  


What do you think holds testers back to do automation? Is there a way to overcome it?

0 Answers  


How could you explain the main difference between webdriver and rc?

0 Answers  


What is data - driven automation?

4 Answers  


What is modular automation?

0 Answers  






Categories