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 is sql query limit?
how to create a database in oracle?
How do I remove sql plus from windows 10?
Can we create clustered index without primary key?
write sub query for eliminating duplicate rows using analytical function?
What are the types of SQL Statement?
What is the difference between function, procedure and package in pl/sql?
What is a ddl command?
What is the purpose of a secondary key?
What is cursor and its types?
which will default fire first statement level trigger or row level trigger
2 Answers Cap Gemini, Data Vision,
Fetch an entire row from the employees table for a specific employee ID: