Hello,
consider these three statements:
create table t (id integer, date datetime ) ;
select id from t group by id ;
select id from t group by id order by max(date) ;
Is it correct behavior that the second select returns one row where
as the first select returns zero rows?
Thanks in advance for any help,
Hein