Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 150609 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 |
What is a deadlock in SQL? How can you prevent it?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to write a query with an inner join in oracle?
can u plz provide me oca sql dumps please i need them
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How do I spool in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Explain the use of indexes option in exp command.
What is a dynamic performance view in oracle?
What is an oracle data file?
What are the differences between char and varchar2 in oracle?
how to retrieve data from different tables ,place this data in different excel worksheets.
Oracle General 
