write a query for the fifth highest salary?
Answer Posted / 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 |
Post New Answer View All Answers
What are database connection details?
How to do Data size testing? Who does this testing (Developer or tester)?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
What is ole db provider for sql server?
What do you mean by database?
Data structure used to implements a menu:
What is the purpose of TNS?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
What is the Difference Primary key and Unique Key
Differentiate between unique key and foreign key?
Which database is best to store images?
If the master device is full, how do I make the master database bigger?
A design problem was given in which I was supposed to make a design for the data base for a given problem.
Explain entity type?
What is a database call?