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]
