How to perform a SELECT DISTINCT - H2

0

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 ?

    
asked by anonymous 06.11.2017 / 14:29

0 answers