Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for the fifth highest salary?
- 17 Answers
- 23981 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
Explain entity ?
What is meant by distributed system?
Explain natural key?
What is sharded database?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
Why merge statement is used inside the database?
What will happen non-clustered index will be created on clustered index?
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
Define stored procedure?
What is database bounce?
5. Explain about relational algebra.
What is odm in database?
