Interested to Buy Any Domain ? << Click Here >> for more details...
How to get Top 10 Salaries from a Table
- 11 Answers
- 28019 Views
- Accenture, HTC, I also Faced
- E-Mail Answers
Answer Posted / shammi
SELECT *
FROM (select * from employee ORDER BY salary desc) employee2
WHERE rownum <= 10
ORDER BY rownum;
correct me if am wrong
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Give the name of some fields form sqlca.
What is the usage of open cursor command?
How can we retrieve the total number of records in RPG & CLLE?
What is the syntax for FETCH in DB2 ?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How is deadlock resolved?
What are the benefits of using the db2 database?
What is the physical storage length of timestamp data type?
What is bind and rebind in db2?
define clustering index.
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How can deadlocks be resolved?
What is the use of runstats in db2?
What is a storage group (stogroup)?
How do you concatenate the firstname and lastname from emp table to give a complete name?
