how to get second highest salary in SQL(as/4000
Answers were Sorted based on User's Feedback
Answer / satheeshkumar
Select max(sal) From Employee where sal not in ( Select max
(sal) From Employee)
Is This Answer Correct ? | 24 Yes | 4 No |
Answer / sachin
select max(sal) from employees
where salary < (select max(sal) from employees);
Is This Answer Correct ? | 19 Yes | 3 No |
Answer / karunakarreddy.boyapally
SELECT DISTINCT A.SAL FROM EMP A
WHERE &N=(SELECT COUNT(DISTINCT(B.SAL)) FROM EMP B
WHERE A.SAL<B.SAL)
IF SUPPOSE IF U WANT 1 HIGEST SALARY GIVE N=1
IF SUPPOSE IF U WANT 2 HIGEST SALARY GIVE N=2
IF SUPPOSE IF U WANT 3 HIGEST SALARY GIVE N=3
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / deepak
select max(sal) from emp where sal!=(select max(sal) from emp);
Is This Answer Correct ? | 12 Yes | 5 No |
Answer / raji_4u
select *
from emp e1
where 2 = ( select count(distinct sal)
from emp e2
where e1.sal <= e2.sal
)
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / selvaraj v , anna univ coe
SELECT * FROM Employee e
WHERE 2=(SELECT COUNT(DISTINCT Salary) FROM Employee x
WHERE x.Salary >= e.Salary);
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sreekanth
SELECT MIN(SAL)
FROM(SELECT DISTINCT SAL FROM EMP
ORDER BY SAL DESC)
WHERE ROWNUM <= :N
where n is the nth highest salary.
In most of the answers,our friends have written 'where
rownum=2',but this never retreives a row.
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / c srirammulu
select * from emp a where &n=(select count(distinct (sal))
from emp f where a.sal<f.sal)
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / devi
select sal from (select sal,rank() over(order by sal desc)
as rank from emp) where rank>1 and rank<3
Is This Answer Correct ? | 4 Yes | 1 No |
what are the demerits of sql?
explain mysql aggregate functions. : Sql dba
Why do we create stored procedures & functions in pl/sql and how are they different?
7. Where would you look for errors from the database design?
Can we create view in stored procedure?
What is rtm in testing?
What is a record in pl/sql?
can we create index on index?
What is differance unique key and primary key.
Write a query to find five highest salaries from EMP table. (there is a column SALARY)
24 Answers Cap Gemini, iNautix,
What are the different types of dbmss?
What is an oracle stored procedure?