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
- 6598 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / girish
select * from agdet a where 5 >= (select commission from
agdet a , agdet b where b.commission > = a. commission)with
ur;
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / thiru
select * from agdet order by commission fetch first 5 rows
only for read only with ur
| Is This Answer Correct ? | 3 Yes | 7 No |
what are bind concepts in db2 cobol?
What is the default page size of buffer pools?
what is difference between Static call and Dynamic call? How does it function?
What are the abend codes occour in ur latest PROJECT in DB2
how to identify the pseudo conversation by seeing the program
Is ibm db2 open source?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
what is a corelated subquerry?
What is db2 look?
What are the three types of page locks that can be held?
What is meant by explain?
COBOL 
