Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 150666 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 are the differences between char and varchar2 in oracle?
How do I manually uninstall oracle client?
How can we view last record added to a table?
what are different types of deletes?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
how to retrieve 1st and last row of table without using group functions??
How oracle handles dead locks?
Explain do view contain data?
How do I reset a sequence in oracle?
What are the uses of Rollback Segment ?
What is recovery manager(rman) backup in Oracle?
Oracle General 
