How to get Top 10 Salaries from a Table
Answer Posted / bharath
select sal from(select ename,sal rownum from emp orderby sal
desc group by sal,rownum)where topsal='&nth';
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
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 is alias in db2?
How to test SQL -911 error while developing COB-DB2 program
Highlight all the advantages that are attached to a package.
Explain in brief how does db2 determine what lock-size to use?
Explain about rct.
What is commit in db2?
Define declaration generator (dclgen).
What is a cursor in programming?
How to execute stored procedure in db2 command editor?
Before you give the explain statement, what are the prerogatives?
What are db2 objects?
How to create backup table in db2?
List down the data types in the db2 database.
What are the contents of a dclmgen?