Categories

Archive

Removing duplicate rows in PostgreSQL, Oracle and SQLite

Sometimes you need to remove nasty duplicate on a table, based on a subset of the column. Oracle trick:

Postgresql equivalent is ctid, so you can try something like

SQLite demo:

  Also take a look at Read more ›