How to process a recordset with 2 customer id's that have diff values

[colezpapa]

I have to process a file that can contain the cust id more than one time. I will need the record with the highest status value. What's the best approach here.
What's the best way to do this...Code or query?
In the example, I would want the GHI with the status = 1.

Cust ID Status

ABC 2
DEF X
GHI 1
GHI 2
NJO 1
MNK X
KNL 2

 

[JoeAtWork]

I will need the record with the highest status value...... In the example, I would want the GHI with the status = 1

So actually you want the record with the lowest status value (last I checked, 1 was less than 2).

SELECT [Cust ID], Min(Status) FROM YourTableName GROUP BY [Cust ID]

 

[colezpapa]

yes, thats correct. I get it backward here and there!!!!
Thanks for your response.