how to check the 3rd max salary from an employee table?
Answers were Sorted based on User's Feedback
Answer / somanath
select sal from emp a where 3=(select
count(distinct(sal)) from emp b
where a.sal<=b.sal)
Is This Answer Correct ? | 34 Yes | 7 No |
Answer / radha sri seshu.kolla
1)SELECT MAX(SAL) FROM EMP WHERE LEVEL=3 CONNECT BY PRIOR
SAL>SAL
2)SELECT E.SAL FROM
(SELECT SAL,DENSE_RANK() OVER(ORDER BY SAL DESC)R FROM EMP)
E WHERE E.R=3
9966112520
Is This Answer Correct ? | 10 Yes | 5 No |
Answer / b.v.siva kumar
Use this for SQL Server:
select top 1 salary from emp where salary in (select
distinct top 3 salary from emp order by salary desc) order
by salary
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / venkateswarulu.s
select min(salary) from emp where salary in(select distinct
top 3 salary from
emp order by salary desc)
Is This Answer Correct ? | 13 Yes | 10 No |
Answer / gourvendra singh
In oracle you can find the 3rd max salary with the help of
the command:-
select sal from(select sal from(select distinct sal from
emp order by sal desc)
where rownum <=3 order by sal asc) where rownum=1;
Is This Answer Correct ? | 7 Yes | 4 No |
Answer / ar
select c.emp_id,c.salary from (select rownum as
rn1,c.emp_id,c.salary from (select * from table_name ORDER
by salary DESC) b) c
where c.rn1 = n --(n=3)
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / danny
SELECT min( sal )
FROM emp
WHERE sal
IN (
SELECT DISTINCT sal
FROM emp
ORDER BY sal DESC
LIMIT 0 , 3
)
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / neeraj79
SELECT DISTINCT salary
FROM employee
ORDER BY salary DESC
LIMIT(2,1)
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / arjun
select min(sal) from (select sal from (select distinct(sal)
from emp order by sal desc) where rownum<4)
Is This Answer Correct ? | 2 Yes | 1 No |
what are the drivers in mysql? : Sql dba
2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
What is pls integer?
What is sqlite format?
What is the difference between left and left outer join?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What does 0 mean in sql?
what is sql.
how to create table with in the procedure or function?
What is a pragma statement?
What are different types of queries in sql?
Which one is better sql or oracle?