Markus Popp wrote:
> Hi!
>
> If you use MySQL 4.1 upwards, you can do it with
>
select y from event where date = (select max(date) from event where
group=somegroup)

Is what you meant. And it will give a row per group.

Bart