write a query for the fifth highest salary?
Answers were Sorted based on User's Feedback
Answer / arshi
SELECT MAX(Salary) AS Expr1
FROM TableName
WHERE (Salary NOT IN
(SELECT TOP (4) MAX(Salary)
AS Expr1
FROM TableName AS
TableName_1
GROUP BY Salary
ORDER BY SalaryDESC))
Is This Answer Correct ? | 6 Yes | 7 No |
Answer / ramesh
select top 1 salary
(select distinct top 5
salary from employees
order by salary desc)
a order by salary
Is This Answer Correct ? | 6 Yes | 9 No |
Answer / sujit
Hop it helps!
Select sal from (select sal from emp order by sal desc
where rownum<6);
Is This Answer Correct ? | 0 Yes | 3 No |
Answer / payal
select salary from emp order by salary desc limit 4,1
Is This Answer Correct ? | 3 Yes | 10 No |
Answer / aravind
select * from (select sal from emp order by desc) emp where
rownum = 5
Is This Answer Correct ? | 6 Yes | 14 No |
Answer / p.chella vijaya
select top 5 (salary) from emp order by desc
Is This Answer Correct ? | 1 Yes | 13 No |
Answer / p.chella vijaya
select top 5 (salary) from emp order by salary desc
Is This Answer Correct ? | 1 Yes | 14 No |
issues involved in modeling and building data werahouses
how do you do sql tuning?
What is the candidate key used for?
How does database replication work?
What is the use of graph database?
Data structure used to implements a menu:
How heap is implemented in database?
How does non-cluster index functions?
Display the employees whose salary is less than average salary.
How do database connections work?
What is table scan and index scan?
give a simple example of physical and logical data independence