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 the current version of postgresql?
What can sql server reporting services do?
How to pipe multiline string to isql?
write an sql query to find names of employee start with 'a'? : Sql dba
How does postgresql compare to mysql?
How many types of functions are there in sql?
How do you modify a table in sql?
I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?
How did you export data from database to excel file.
Whis is not false in primary key?
what is bdb (berkeleydb)? : Sql dba
What is the usage of sql functions?