Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for the fifth highest salary?
- 17 Answers
- 24377 Views
- IBM, Matlabs, Ramco, I also Faced
- E-Mail Answers
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
Explain the record term used in database.
what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
List some advantages of dbms.
What is database and its types?
Should I store images in database?
aht is the difference b/w network & hierarchial & relational dbms????
What is the importance of database partitioning?
What will happen non-clustered index will be created on clustered index?
Under which circumstance should you create an index on a table?
What is a reference table in database?
Is it good to store images in database?
What is replicaset?
Explain the field term used in database.
Explain storage manager?
What is meant by distributed system?
