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 KIND OF TOOL BO IS?
What are the types of joins?
0 Answers Tavant Technologies, Zensar,
What are the two categories of Client-Server application development?
What is the use of default key?
What is the best database?
hOW TO LOAD SOURCE INTO TARGET 2 TIMES?(INFORMATICA)
how do you do sql tuning?
Display the employees whose salary is less than average salary.
what is the difference between tuple calculus and domain calculus ?
What is a reference table in database?
What is the candidate key used for?
5. Explain about relational algebra.