Brian try this... Select user_id, max(submit_number) from tAnswers Group by user_id
Cheers ____________________________ Matthew Kernick Development Team Leader Director eNTITy1 Pty Ltd p +61 8 8941 1162 f +61 8 8941 1167 e [EMAIL PROTECTED] w www.entity1.com ____________________________ -----Original Message----- From: Beattie, Barry [mailto:[EMAIL PROTECTED] Sent: Tuesday, 26 August 2003 3:44 PM To: CFAussie Mailing List Subject: [cfaussie] RE: selecting the max ID is this what you meant? select max(submit_number) from tAnswers Where user_id = XXX cheers barry.b -----Original Message----- From: Knott, Brian [mailto:[EMAIL PROTECTED] 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/ --- 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/
