I need to make a SELECT DISTINCT
in the database H2
but in the way I'm doing it is not returning me anything:
SELECT DISTINCT lote
FROM LotesEncerrados l
ORDER BY l.lote ASC
I did the same thing on PostgreSQL
and it worked fine. How could I do in H2
?