Skip to Content
0
Former Member
Jul 14, 2005 at 03:55 AM

validating records during data retrieval

14 Views

Hi,

i have a database table with fields ID and NUMBER which contains several records with the same id and different number

example.

-ID-| NUMBER

id123| 1

id123| 3

id123| 2

i need to pick up the record with maximum NUMBER value.in this case with ID123 and NUMBER 3.

how to code the select query.

any help would be appreciated.

thanks,

kranthi.