Re: Selecting dupes from table

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
Cc: Uros <uros(at)sir-mag(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Selecting dupes from table
Date: 2003-06-24 16:38:51
Message-ID: 20030624163851.GA13714@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jun 24, 2003 at 19:31:46 +0900,
Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> wrote:
>
> Try:
>
> select id,url,title from directory where group by id, url, title having
> count(url) > 1 order by url;

That won't work because the count is over the triples, rather than just
the url.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Reuben D. Budiardja 2003-06-24 16:40:46 Re: [GENERAL] Documentation quality WAS: interesting
Previous Message nolan 2003-06-24 16:33:30 Re: table alias on update, another update question