A few ways to do this: http://www.sql-ex.ru/help/select17.php
> Is there any way to remove a duplicate row from a table? Not my db but I have > to work with it. On version 7.4 right now. > Edward W. Rouse > Comsquared System, Inc. > 770-734-5301 > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql