write a query for the fifth highest salary?
- 17 Answers
- 19567 Views
- IBM, Matlabs, Ramco, I also Faced
- E-Mail Answers
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 the difference between primary key, foreign key and candidate key?
Can a database table exist without a primary key?
What is the Difference Primary key and Unique Key
Explain artificial key?
List the properties of a transaction.
What is the best database?
Explain the field term used in database.
What is odm in database?
what is tkprof tool and how it is used???
Explain transaction manager?
What is a super key?
List various types of log-based recovery in DBMS.
Explain entity type?
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
Explain database partitioning. What is its importance?
