Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151319 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 / biswapratap singh
SELECT MIN(sal) FROM emp WHERE
sal IN (SELECT distinct TOP 3 sal FROM emp ORDER BY sal DESC)
| Is This Answer Correct ? | 214 Yes | 73 No |
Answer / neha
select max(sal) from emp where sal <(select max(sal)from emp
where sal<(select max(sal) from emp));
| Is This Answer Correct ? | 103 Yes | 31 No |
Answer / sanjeev kumar p
select * from emp e1 where (3-1) = (select count(distinct
(e2.sal)) from emp e2 where e2.sal>e1.sal)
| Is This Answer Correct ? | 99 Yes | 51 No |
Answer / arijit
donno whether the rest are correct ..but this one is:-
select max(sal) from emp where sal<(select max(sal) from emp
where sal<( select max(sal) from emp));
| Is This Answer Correct ? | 52 Yes | 17 No |
Answer / harmeet
Hi, this query will gives the third highest salary from table
select * from emp e
where 3 = (select count(sal) from emp
where e.sal < sal);
To dispay 5th highest salary, just change the number 3 to 5.
Like that we can find top N salaries.
I hope i'm not wrong.
| Is This Answer Correct ? | 44 Yes | 16 No |
Answer / akshita
select * from (select e.*,rownum r from (select distinct
sal from emp order by sal desc) e) where r = 3
| Is This Answer Correct ? | 43 Yes | 16 No |
Hi every body,
I give the standard format Query for this type of top most
and who are the top n people in the organization like that
If we take EMP table
Select * from EMP A where &n= (select count (distinct
(sal)) from EMP B where B.sal>A.sal)
If we give n value 1 or 2 or 3….etc then we gets top one,
top second, and top third person details.
This same query can we use top n people who are earning
maximum salaries in the Organization
Select * from EMP A where &n> (select count (distinct
(sal)) from EMP B where B.sal>A.sal)
| Is This Answer Correct ? | 38 Yes | 19 No |
Answer / punit chauhan
select * from emp where sal<(select max(sal) from emp
where sal<(select max(sal) from emp))
punit chauhan
iMS NOIDA
doing MCA
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / punit chauhan
select * from emp_record e1 where (3-1) = (select count ( distinct (e2.salary)) from emp_record e2 where e2.salary > e1.salary
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / selvaraj anna university coe
In ORACLE 10g,
SELECT * FROM employee x WHERE 3 = (SELECT COUNT(DISTINCT
salary)
FROM employee y WHERE x.salary <= y.salary);
| Is This Answer Correct ? | 16 Yes | 5 No |
What is Oracle table?
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
What is an anonymous block?
What is the difference between primary key and unique key and foreign key in oracle?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
What to do if the binary spfile is wrong for the default instance?
What happens if you set the sga too low in oracle?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
How to drop an existing table in oracle?
What are the general rules on data consistency?
Oracle General 
