Replace/Simplify row values to eliminate duplicates

[mlauber71]

This thread and the discussion might be relevant for you:

Delete duplicates

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). *1) http://www.h2database.com/html/changelog.html