How to get Top 10 Salaries from a Table
Answers were Sorted based on User's Feedback
Answer / abirami
select max(salary) from tablename
fetch first 10 rows only
| Is This Answer Correct ? | 4 Yes | 25 No |
What is QUIESCE?
What is the difference between bind and rebind in db2?
how to identify the pseudo conversation by seeing the program
What is the connection string to connect to the DB2 Database ?
How to resolve -818 sql code in DB2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What does the REORG Utility do?
What is the advantage in De-normalizing tables in DB2?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
What does CURRENTDATA option in bind indicate
What is the syntax for FETCH in DB2 ?
what is SMP/E? and what are the major steps of it? thanks...