English Content / Knowledgebase / Structured Query Language (SQL) 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. On every big database there is something called “rowid” which can be used …