[SQL] How can I produce the following desired result?

131   0.000  09-26-2003 54  3 550.000  09-26-2003 49     I need   to select rows which storehistoryid is max as the same goodid .     Thanks  in advance      aicean Mailto:[EMAIL PROTECTED]

Re: [SQL] How can I produce the following desired result?

Thanks very much. It seems can solve my problem.For select the max "storehistoryid",I have to compare each row's storehistoryid. Any other advice? Thanks again. aicean Mailto:[EMAIL PROTECTED] - Original Message - From: "Rod Taylor" <[EMAIL PROT