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 table scan and index scan?
Is data lake a database?
Is it good to store images in database?
Give the syntax of exception handling used in DBMS?
A design problem was given in which I was supposed to make a design for the data base for a given problem.
What is the difference between primary key, foreign key and candidate key?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
What is a Database?
Which three commands cause a transaction to end?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
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?
How do I setup a database connection?
What is the purpose of TNS?
what is the role of auditor in auditing data oriented applications?
Can you tell any two advantages of stored procedures?