How to get Top 10 Salaries from a Table
Answer Posted / samsunisa
select top 10 salary from table name order by salary;
| Is This Answer Correct ? | 7 Yes | 19 No |
Post New Answer View All Answers
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What do you mean by cursor?
What is dbrm? What it contains? When it will be created?
What is ibm db2 used for?
What is the purpose of using commit?
What is the physical storage length of the data types date, time, and timestamp?
What is bind package and plan 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 are the uses of db2 optimizer?
Explain db2.
How many databases can be created inside an instance in db2 ?
What is precompiler in db2?
What is alias in db2?
How can record locking be achieved in those DB2 versions which do not support it?
What is null in db2?