> I haven't been able to come up with a HAVING clause ... HAVING is used to select (or eliminate) groups, so it doesn't apply here; you want all the groups. Also remember that, although it doesn't generate a syntax error, it's not correct to specify an aggregate function and a column that's not in the GROUP BY clause: 'select max(t), x ... group by x' is OK, but 'select max(t), x, y ... group by x' is not.
select t, x, y from tbl, (select max(t) tmax, x xx from tbl group by xx) where t = tmax and x = xx; (I changed your table name just to make it easier to read.) Regards
