how to get data with newest date

[nubi3]

I have this table.
Prod PurDate Loc
65 03/25/2013 San Diego
64 04/25/2013 Los Angeles
64 01/12/2013 San Francisco
65 04/25/2013 Sacramento


and i want to extract records with newest entry on each product (Prod), like this.

64 04/25/2013 Los Angeles
65 04/25/2013 Sacramento

here is what i attempted so far but, the result is not what i want.

Select Max(Purdate), Prod, Loc
from products
group by Prod, Loc

can anyone suggest a better query?

thanks,

[pbaldy]

How about:

http://www.baldyweb.com/LastValue.htm

[nubi3]

thanks pbaldy. can i do it in one SQL statement w/o using a query and joining it with the table? your solutions works great btw.

[pbaldy]

The first query could be a subquery to the second, but I feel that gets too messy work with.