Delete duplicates

[mlauber71]

You could use a SQL function with row numbers and only keep two. The mentioned example is from a big data workflow. But it seems H2 is also allowing to use

row_number()

function *1).

Duplicate Row filter

I can add one more idea to use SQL and row_number if you have an ID that would indicate a duplicate entry. SELECT * FROM ( SELECT * , row_number() over (partition BY `ID` ORDER BY `date` DESC) AS `rank_id` FROM `default`.`data1` ) t1 -- only keep the entry that will be -- left on top of a group of identical v_name WHERE `t1`.`rank_id` = 1 ; https://forum.knime.com/t/remove-rows-with-duplicate-values/11105/15?u=mlauber71

*1)
http://www.h2database.com/html/changelog.html