Re: Data with Max Qty and Date ?

this also works,

select * from mtran where
(itemid,qty) in (select itemid,max(qty) from mtran group by itemid) Received on Thu Aug 12 2004 - 00:53:04 CDT