Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 126117 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 the challenges using QTP11, QC11 with SAP TAO?
if i want to use different values in datatable with each iteration of for loop what would i do ??/
What is in-house tool?
Tell us how can you find if an element is displayed on the screen?
Do you know what is the purpose of creating a reference variable- 'driver' of type webdriver instead of directly creating a firefoxdriver object or any other driver's reference in the statement webdriver driver = new firefoxdriver();?
How to find that tools work well with your existing system?
is there any Rational Functional Tester certification questions available?
5. What are the tests you are conducting through winrunner?
How the object properties will be recognised by the tool If the functions/ statements are written manually?
How can you switch back from a frame?
Can you achieve 100% automation?
How do you plan test automation?
WinRunner 
