Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151424 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 / swaminathan
select *
from (select distinct sal from emp order by sal desc)
where rownum <= 3
| Is This Answer Correct ? | 9 Yes | 13 No |
Answer / amitabh sharma
Here are 2 queries for finding 3rd highest salary:
select * from emp e
where 3 = (select count(sal) from emp
where e.sal < sal);
SELECT * FROM
(
SELECT Ename, SAL, dense_Rank() OVER (ORDER BY SAL DESC )
RANKNEW FROM EMP)
WHERE RANKNEW = 3
Regards,
Amitabh Sharma
| Is This Answer Correct ? | 1 Yes | 5 No |
Answer / ruchira
select sal from emp
where sal =
(select sal from
(select distinct sal from emp OrderBy sal desc)
[table alias] where rownum < 4 )
| Is This Answer Correct ? | 1 Yes | 5 No |
Answer / sapna rawal
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary ;
n=3.In this case.
| Is This Answer Correct ? | 1 Yes | 5 No |
Answer / anirban mitra
SELECT MAX(SAL) FROM EMP WHERE SAL NOT IN (SELECT MAX(SAL)
FROM EMP UNION SELECT MAX(SAL) FROM EMP WHERE SAL NOT IN
(SELECT MAX(SAL) FROM EMP))
| Is This Answer Correct ? | 2 Yes | 7 No |
Answer / nagaraj a h
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
| Is This Answer Correct ? | 0 Yes | 5 No |
Answer / dayaram & sarfaraz (dost)
select a.empno,a.ename,a.sal from emp a
where &n = (select count(distinct(b.sal)) from emp b where
b.sal>= a.sal
| Is This Answer Correct ? | 0 Yes | 5 No |
Answer / asadullahrao
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 | 6 No |
How to define default values for formal parameters?
T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"
Why do you use stored procedures and state some of its disadvantages?
How can windows applications connect to oracle servers?
How do I start tns listener?
Explain coalesce function?
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
how to find out largest value in a table
What happens to the current transaction if a ddl statement is executed?
How to write a query with a right outer join in oracle?
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Oracle General 
