Interested to Buy Any Domain ? << Click Here >> for more details...
i have table agdet i want first 5 maximum commission which
query will you write for this thanks in advance
- 3 Answers
- 6862 Views
- I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
exec sql
select commission from agdet order by commission desc
fetch first 5 rows only
end-exec;
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are iseries servers?
List out the three types of page locks that can be held.
What are union and union all?
How connect db2 database to datastage?
Which command is used to remove all rows from a table?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is null indicator in cobol db2?
What is the syntax for FETCH in DB2 ?
What is load utility in db2?
What is explain in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the difference between cursor and select statement?
Describe major components of db2?
Is the primary key a clustered index?
How to create backup table in db2?
