Id Bal  Saved
1  100  2/5/2008
1  90   2/6/2008
1  80   2/7/2008
2  250  2/6/2008
2  150  2/9/2008


I am tring to create a query that will give me the following result set:

Id Bal  Saved
1  80   2/7/2008
2  150  2/9/2008

i.e., one record per Id that has the newest date.

Thanks,
Einar

Semper ubi sub ubi.