Hi there,

I have a tricky SQL problem which I have been trying to solve.

Sales Table
ID ItemNo SaleDate SalesID
1 123 01/01/2011 100256
2 100 03/01/2011 265568
3 102 01/01/2011 654882
4 123 04/01/2011 235854
5 100 10/01/2011 323158


I want the SQL to only return only the latest SalesID for each item so I would like the result to be:
Results
ID ItemNo SaleDate SalesID
3 102 01/01/2011 654882
4 123 04/01/2011 235854
5 100 10/01/2011 323158