Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for the fifth highest salary?
- 17 Answers
- 25002 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
What are different types of data models available? Explain with example?
What is relational database with example?
Explain entity set?
What is a database connection string?
What is database bounce?
Differentiate between unique key and foreign key?
sparse lookup and where its options we find in OCI and db2?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
What is the database url?
Difference between sql and mysql?
what are wrappers and build ups and what it's use?
Write a query to retrieve for many to many relationships?
What is ole db used for?
How many types of locks are present in a database?
Explain normalization in one line?
