Re: Group by

[Roland Bouman]

For 3.23, you should probably solve it by doing it in two steps.

The first step would store the the result of the group by in a (temporary) table;
the second step would join the temporary table to the original data set:

insert
into my_temp_table(
id int
)
select max(id)
from table1
group by col1
;

select t1.*
from table1 t1
inner join my_temp_table tt1
on tt1id = t1.id
;