write a query for the fifth highest salary?
Answers were Sorted based on User's Feedback
Answer / venkates
select distinct(a.sal) from emp a where 5=(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)
Is This Answer Correct ? | 22 Yes | 2 No |
Answer / nitin bisht
SELECT empSalary FROM empTable e1 WHERE (5 = (SELECT
COUNT(DISTINCT (e2.empSalary))
FROM empTable e2 WHERE e2.empSalary >= e1.empSalary))
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / piyush gupta
select distinct(a.sal) from emp a where 5=(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)
you can this query for nth highest salary
replace 5 with any number
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prasanna
select max(sal) from emp where sal not in (select Top 4 sal
from emp order by sal desc)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shahid
select *from(select sal,rank() over(order by sal desc)as sal_rank from emp) where sal_rank=5;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / bhramar
select top 1 Sal from(select distinct top 5 Sal from TestEmp order by Sal desc) a order by Sal
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / suparna
select salary from employee e where 4=(select count(*) from
emp f where e.sal<f.sal)
Is This Answer Correct ? | 8 Yes | 8 No |
Answer / chethan
select Salary from ( select salary from emp order by desc) as employee where rownum = 5;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bezalel
select salamt from
(
select rownum n,salamt from
(
select distinct salamt from emp order by salamt desc
)
)
where n=5
Is This Answer Correct ? | 0 Yes | 0 No |
WHAT IS CARDINALITIES OF JOIN?
write a query for the fifth highest salary?
17 Answers IBM, Matlabs, Ramco,
How do you connect to a database?
What will happen non-clustered index will be created on clustered index?
Explain natural key?
Should I store images in database?
how do you do sql tuning?
What is a database string?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
What is the use of default key?
Explain inner and outer joins with examples.
Why merge statement is used inside the database?