I have problem with query DISTINCT ON in H2.
I am using H2 connector (in-memory).
My test table looks like
My query using DB Query
SELECT DISTINCT ON (“Product”) * FROM #table# “t1” ORDER BY “Product”, “Date” DESC;
But I get error
The result of my query should be
Thanks in advace for help.