Re: Removing duplicate rows in table

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Removing duplicate rows in table
Date: 2024-09-12 12:41:32
Message-ID: dfaf7fcb-a7-6587-50f0-696dbb956ee7@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 12 Sep 2024, Muhammad Usman Khan wrote:

> You can try the following CTE which removes all the identical rows and only
> leave single row

Thank you, Muhammed.

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2024-09-12 13:05:48 Re: Effects of REVOKE SELECT ON ALL TABLES IN SCHEMA pg_catalog FROM PUBLIC
Previous Message Dominique Devienne 2024-09-12 12:40:36 Re: Backward compat issue with v16 around ROLEs