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,
EinarSemper ubi sub ubi.