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
- 6679 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 is Static and dynamic linking
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Is db2 a programming language?
Where is the access path logic created by the DB2 Optimizer stored?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
What is DYNSLT keyword? How do you perform selection using DYNSLT
What is rct?
How to resolve -803 sql code in DB2?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What is correlation names?
How to insert more than one record using insert?
What are union and union all?
COBOL 
