Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for the fifth highest salary?
- 17 Answers
- 24401 Views
- IBM, Matlabs, Ramco, I also Faced
- E-Mail Answers
Answer Posted / piyush gupta
select distinct(a.sal) from emp a where 5=(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)
you can this query for nth highest salary
replace 5 with any number
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain database partitioning.
What is the function of cluster index?
What are the various ways to execute a query in teradata?
What is a super key?
What are different types of clusters present?
Write a query to get maximum and second maximum in oracle?
Explain entity ?
what is rcp,if rcp disabled what happen?
Differentiate between extension & intension?
5. Explain about relational algebra.
Explain natural key?
How to do performance tunning a database in DB2 V8.2 UDB in linux
Explain the record term used in database.
Explain artificial key?
Which is the best graph database?
