Consider the table:

Sn   Bal  DateSaved  TimeSaved
1    200  2/5/2008   10:00
1    175  2/5/2008   11:00
1    123  2/5/2008   13:00
1    111  2/6/2008   08:00
1    101  2/6/2008   18:00
2    500  2/8/2008   10:00
2    475  2/8/2008   11:00

I am trying write a query that will give me the following result set

Sn   Bal  DateSaved  TimeSaved
1    101  2/6/2008   18:00
2    475  2/8/2008   11:00

1 record per Sn where the DateSaved and the TimeSaved (together) is the newest datetime.

Thanks,
Einar