Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 150672 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
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 |
what are the default admin accounts in Oracle 10g ?
Explain table?
How to count groups returned with the group by clause in oracle?
what are stored procedures?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is raw datatype?
How to assign data of the deleted row to variables?
How to define an anonymous procedure without variables?
What are the types of partitions in oracle?
How to experiment a data lock in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
how to select second mauximum value in a given table under salary column
Oracle General 
