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:00I 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:001 record per Sn where the DateSaved and the TimeSaved (together) is the newest datetime.