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
- 6757 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 |
Give a brief description of db2 isolation levels?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
The only place of VSAM KSDS in DB2 is?
How can you display the current date & current time ?
Describe the elements of the SELECT query syntax?
What is check constraint in db2?
What is difference between rollback and commit?
What is db2 catalog database?
Why select is not preferred in embedded sql programs?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
What is query_cache_limit?
COBOL 
