Gday, I have a table that shows a series of scores and datetimes those scores occurred.
I'd like to select the maximum of these scores for each day, but display the datetime that the score occurred.

I am using an Oracle database (10g) and the table is structured like so:

```
    scoredatetime                score (integer)
    ---------------------------------------
    01-jan-09 00:10:00      10
    01-jan-09 01:00:00      11
    01-jan-09 04:00:01      9
    ...
```

I'd like to be able to present the results such the above becomes:

```
 01-jan-09 01:00:00      11
```

This following query gets me halfway there.. but not all the way.

```
select 
   trunc(t.scoredatetime), max(t.score)
from 
   mytable t
group by
   trunc(t.scoredatetime)

```

I cannot join on score only because the same high score may have been achieved multiple times throughout the day.

I appreciate your help!

Simon Edwards