Re: How to delete completely duplicate rows

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Janek Sendrowski <janek12(at)web(dot)de>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to delete completely duplicate rows
Date: 2014-01-02 16:56:01
Message-ID: CAHyXU0xfa6kSbtGenFTZna6a2UT9nQoO65TV=b1jKGY+QZEHvA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jan 2, 2014 at 4:33 AM, Janek Sendrowski <janek12(at)web(dot)de> wrote:
> Thanks!
> It's working

you can do it without listing columns via:

select *, row_number() over(partition by c) from c;

emphasis on 'partition by c'.

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message john.tiger 2014-01-02 19:19:52 json query problem
Previous Message Abdul Sayeed 2014-01-02 12:32:27 Re: How to list and describe tables in psql???