Write a query to find second highest salary of an employee.
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Answer / n.tejaswi
Select Empname
from emp LIMIT 2
orderby empsal;
Is This Answer Correct ? | 2 Yes | 1 No |
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 |
Answer / ujwlala
select max(salary) from employee where salary<>(select
max(salary) from emp)
Is This Answer Correct ? | 2 Yes | 1 No |
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 |
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 |
Is ui level testing possible?
Tell us what automation tools could be used for post-release validation with continuous integration?
1. How would you Test & then automate an antivirus application? 2. How would u test & automate windows screen saver? (expected: “test scenarios” & “test approch”: points)
Tell us what is the difference between single slash (/) and a double slash ( //) in xpath?
Describe common problems of test automation.
what are categories in step generator?
Does every software project need testers?
Explain me what the webdriver supported mobile testing drivers do you know?
What is difference between selenium and QTP tools Which is best tool... Which is most used tool
Why do you prefer selenium automation tool?
How can the user get a text of a web element?
Explain Bug Life Cycle and expalin briefly each 'Status' also