Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Data with Max Qty and Date ?
hi all,
I am really do not know how to get this. Tried all types of queries. The requirement is as below
itemid maxqty Mdate (date is when the max qty went out)
001 5 5/1/2004 002 2 5/10/2004
The actual table has all transaction data as below. itemid qty date
001 5 5/1/2004 001 3 5/2/2004 001 3 5/3/2004 001 2 5/4/2004 002 0 5/1/2004 ..... 002 2 5/10/2004
one query is
select itemid,max(qty) from mTran
with the above require which date it occurred.
Please help
Cap2010 Received on Wed Jul 28 2004 - 02:42:52 CDT