Thanks, sorry man bad. I should have mentioned that each record has a unique key, and this doesn't work.

DATA:

unique key product Id Product Name purchase DATE

1 11111 Book 2002

2 22222 Vase 2004

3 33333 PC 2006

4 33333 PC 2007

I'd like my query to return

Unique key product Id Product Name purchase DATE

1 11111 Book 2002

2 22222 Vase 2004

4 33333 PC 2007