last status

[piulibero]

hi to all,i have a problem that may seem silly to most of you.

my table looks like:
ID CUSTOMERID NAME
-------------------------------------
1 12345 JOHN
2 12345 JOHN
3 56789 ANGELO
4 56789 ANGELO
5 56789 ANGELO
6 56789 ANGELO
7 87654 TIM
8 87654 TIM
9 87654 TIM

the outcome i'd desire is like this:

2 12345 JOHN
6 56789 ANGELO
9 87654 TIM


thank you

 

[swampBoogie]

select max(id),customeid,name
from t
group by customerid,name