Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 147704 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 / dilip tiwari
THis is for Oracle
SELECT * FROM emp
(SELECT empname,Salary,dense_rank() OVER(ORDER BY salary
DESC) AS ranking FROM emp)
WHERE ranking = 3
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bhagayraj
SELECT *
FROM Emp e1
WHERE (2) = (
SELECT COUNT(DISTINCT(e2.Salary))
FROM Emp e2
WHERE e2.Salary > e1.Salary)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rajeevgeu
select rownum,salary from(select rownum r,salary from emp order by salary)where r=3;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / madhu
To find nth salary:
SELECT SUBSCRIBER_no
FROM (SELECT SUBSCRIBER_NO, ROWNUM R
FROM (SELECT DISTINCT SUBSCRIBER_NO
FROM SUBSCRIBER
ORDER BY SUBSCRIBER_NO DESC))
WHERE R = &R
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sukanya
select max(sal) from emp where sal<
(select max(sal) from emp where sal <
(select max(sal) from emp));
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / daji surwase
select salary
from employees
order by salary desc
offset 2 rows fetch next 1 row only;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chandiran
select * from (select sal, rownum r from Employee
order by sal desc)
where r=3
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / ayaz mahmood
select max(sal) from emp
where sal= (select max(sal) from emp
where sal< (select max(sal) from emp
where sal< (select max(sal) from emp)))
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / haneef
Best One
select top 1 * from test_emp where sal in (select top 3 sal
from test_emp order by sal desc) order by sal asc
or
It also work
select top 1 * from test_emp where sal in (select top 3 sal
from test_emp order by sal desc) order by sal asc
select top 1 MAX(sal),id from test_emp where sal < (select
max(sal) from test_emp where sal < (select max(sal) from
test_emp))
group by id,sal order by sal desc
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / abhay
Select Top 1 sal from (select distinct top 3 sal from emp
order by sal desc)a order by sal
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the meaning of recursive hints in oracle?
Can group functions be used in the order by clause in oracle?
How to connect to a remote server?
Explain the use of rows option in imp command.
What is a named program unit?
 How to use an oracle sequence generator in a mapping?
How do I limit the number of rows returned by an oracle query after ordering?
How to update values in a table in oracle?
what is reindexing?
What happens to the current transaction if a ddl statement is executed?
What is a user account in oracle?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
Oracle General 
