write a query for the fifth highest salary?
- 17 Answers
- 19600 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 partial key?
What is the difference between database and server?
What does specialization in DBMS mean?
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
What does currency type mean in database?
What are different types of data models available? Explain with example?
What is the database url?
how can you perform lookup range in lookup stage expalin in detail?
What is redis good for?
What are different types of resources?
What do you mean by foreign key and primary key?
how do you do sql tuning?
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
When should you not use firebase?
What is a database lookup?
