query based on max date

[vranjit138]

Hi i have the following fields Product----Date

W1234----2/23/2009
w1234----2/24/2009
w1234----2/25/2009

Now i have inserted a new field "maxvalue" and i need the following result

Product-----Date-------maxvalue
W1234----2/23/2009
w1234----2/24/2009
w1234----2/25/2009----maxdate

I need a query which will detect the last date for each products. i have nearly 4000 such products

Please help

 

[james_lankford]

select 
  Product, 
  max ( [Date] ) as maxDate
from
  your_table
group by 
  [Product]