write a query for the fifth highest salary?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between data source and database?
What is sharded database?
What are the disadvantages of views in a database?
What is a database call?
how node connect with cpu?
How many indexes can be created on a table?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
can u combine pipeline parallelism and partition parallalism? how and whan?
What are different types of clusters present?
what is tkprof tool and how it is used???
What is the relationship that exists inside in E-R diagram?
How do you pass parameter in stored procedure?
What is a database lookup?
Explain partial key?
Should I store images in database?