Dear Sir, I have created a table with following schema:
CREATE TABLE logging ( id bigint NOT NULL GENERATED ALWAYS AS IDENTITY PRIMARY KEY, nodeid bigint, actor varchar(256) NOT NULL, eventtime timestamp default current_timestamp, action varchar(256) NOT NULL, objectname varchar(256) NOT NULL ); When I executing query like select max(eventtime) from logging where id > 10 group by action order by eventtime desc ; It returns ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions. But it works without order by select max(eventtime) from logging where id > 10 group by action; I am using embedded mode Thank you very much Regards Chris
