How do I delete only 1 of the duplicate records?
column_name | column_id ---------------------+-------------- test1 | 5 test1 | 5 I've tried this: tmp_test=# delete from test where column_id = 5 limit 1; ERROR: parser: parse error at or near "limit" I'm using version 7.2.1 Thank you. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
