A B wrote:
I have a table with rows like this A 1 A 1 B 3 B 3 C 44 C 44 and so on.and I want it to be A 1 B 3 C 44 so how can I remove the all the duplicate lines but one?
CREATE TEMP TABLE tmp AS SELECT DISTINCT * FROM t1; DROP TABLE t1; CREATE TABLE t1 AS SELECT * FROM tmp; -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general