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
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
How to create db2 table in mainframe?
What type of database is db2?
What is the latest version of ibm db2?
What are the prerogatives?
What is the maximum length of sqlca?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is phantom read in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
what is diffrence b/w file-aid tool and file-aid utility???
What are db2 objects?
What is runstats and reorg in db2?
What is ibm db2 connect?
What is the use of commit in db2?
What is sqlca?