do you have a suggestion of the SQL that would do that ? regards, bogdan ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 21, 2004 4:17 PM Subject: Correlated sub query in torque
> does anybody know how to construct a criteria to retrieve the record with > the highest sequence number from a sub group of records (nbr column) using > the data and table structure below? > > id seq nbr amount > 12 1 500 500 > 13 2 500 400 > 14 3 500 450 > 15 1 501 400 > 16 1 502 200 > 17 1 503 350 > 18 1 504 325 > 19 2 504 325 > > i would like to be able to retrieve id 14, 15, 16, 17, and 19 only. > > thanks, > nf > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
