write a query for the fifth highest salary?
Answer Posted / skumar
Hi, friends This one is working fine. I have tested.
SELECT TOP 1 t.esal
from
(
select top 5 esal from employee order by esal desc
) t
order by t.esal asc
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
What is sharded database?
hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
Is storing images in a database a good idea?
What is ole db source in ssis?
Which database does facebook use?
Why do we need distributed database?
What is a driver in database?
What are different types of resources?
can we delete autodiff back up that we have set through sql server agent.
What is ole db used for?
Write a query to retrieve for many to many relationships?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
What is difference between clustered, non-clustered and unique index?
There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?
What is the difference between specialization and generalization?