find out the third highest salary?
Answers were Sorted based on User's Feedback
Answer / hanumantha r challa
select * from emp a where &n=(select count(b.sal) from emp
b where b.sal>=a.sal);
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / raghav
select * from (
select Name,
Salary,
Dept,
Rank()over (order by salary desc) RANK
from Employee)
where RANK = 3
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / joel
select sal from emp
where sal<(select max(sal) from emp
where sal in (select sal from emp
where sal < ( select max(sal) from emp)))
| Is This Answer Correct ? | 6 Yes | 8 No |
Answer / sudesh indore
select ( salary) as sal from employee ORDER by
salary DESC limit 2,1
------------
i hope that will help u thanx
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / esha gautam
SELECT SAL FROM EMP E WHERE &N-1 =(SELECT COUNT(*) FROM EMP
WHERE E.SAL<SAL);
HERE N FOR NTH SALARY!!!!!!!!!!!!!!!!!!!!
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / amrish singh
this is the query for retrieving nth highest salary from
table emp
select e.sal
from emp e
where n-1=(select count(*) from emp s where s.sal>e.sal)
putting the value of n we get the required result.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / venkatranjith e
Hi All,
This query will give you the o/p.
Select * from EMP A where &n= (select count (distinct
(sal)) from EMP B where B.sal>A.sal)
n = 3 , to display 3rd largest salary.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / vishawjeet saini
SELECT MIN(sal) FROM emp WHERE
sal IN (select sal from emp order by sal desc limit 3)
Its works on almost databases including postgres.
| Is This Answer Correct ? | 0 Yes | 2 No |
forget the book first
Empsal table data
700
500
100
900
400
200
600
750
query to find second highest salary from table Empsal
mysql>select distinct(max(e.salary)) from Empsal e
>where e.salary in(
>select e1.salary from Empsal e1 where e1.salary<(select max(salary) from Empsal));
Output=750
query to find third highest salary from table Empsal
mysql>select distinct(max(e.salary)) from Empsal e
>where e.salary in(
>select e1.salary from Empsal e1 where e1.salary<
>(select max(e1.salary) from Empsal e1
>where e1.salary IN(
>select e2.salary from Empsal e2 where
>e2.salary<(select max(salary) from Empsal))));
Output=700
don't args without run
amitsing2008@gmail.com(amy is back again)
| Is This Answer Correct ? | 3 Yes | 5 No |
Answer / arungkd
Hey dudes ,
i have worked out this question and got the Answer.... here
it is given below...
SELECT min(income) AS salary FROM [user] WHERE income in
(SELECT DISTINCT top 3 income FROM [user] order by income
desc )
| Is This Answer Correct ? | 3 Yes | 6 No |
Explain the use of parfile option in exp command.
Hi Can any one tell me what are the API's used in requisition import.
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
How to set a transaction to be read only in oracle?
What is the parameter mode that can be passed to a procedure?
How to start your 10g xe server?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
Explain the characteristics of oracle dba?
how to retrieve daily sal from emp table in oracle 10g
Can you tell me how to add new column in existing views?how?How is possible?
What is clusters ?
what is the dual table in oracle?