Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 126160 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
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 |
What are principles of good testing scripts for automation?
Can test automation improve test effectiveness?
What is a framework and what are the frameworks available in rc?
Could someone educate me on automation testing process followed in a company. I have a vague idea, but i need concrete answers. And thank you all in advance.
Tell me what are pros and cons of automating tests at ui layer?
Please explain what is a relative xpath?
worksoft automation tool how do you create process ?
Explain what is a relative xpath?
What is a ‘test plan’? What is a ‘test case’?
How to download QTP 9.5 Trail version? please explain the complete process?
IN AN APPLICATION HOW DO YOU IDENTIFY THE TASKS WHICH SHUD BE DONE MANUALLY AND WHICH SHUD BE AUTOMATED?
22. Scenario: There are 1 to 100 numbers. Each number should be keep in the each column like from A column to Z column ie 1 to 26. From 27 to 52 should be in 2nd row in the excel sheet. This has to be continue till 100. How do you write Java program and what are various methods.
WinRunner 
