Okay with that data all you need is a Group By and a Max(PurchaseDate)
Select
product_id,
product_name,
Max(purchase_date) as last_purchase_date
From
table
Group By
product_id,
product_name
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question