Select user_id, max(submit_number) >From table Group by user_id
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Knott, Brian Sent: Tuesday, 26 August 2003 4:10 PM To: CFAussie Mailing List Subject: [cfaussie] selecting the max ID If I have a table that contains answer, user_id and submit_number now do I retrieve the maximum submit numbers for each user. Brian Knott --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
