Re: Selecting dupes from table - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Selecting dupes from table
Date
Msg-id 20030624163851.GA13714@wolff.to
Whole thread Raw
In response to Re: Selecting dupes from table  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
On Tue, Jun 24, 2003 at 19:31:46 +0900,
  Jean-Christian Imbeault <jc@mega-bucks.co.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.

pgsql-general by date:

Previous
From: nolan@celery.tssi.com
Date:
Subject: Re: table alias on update, another update question
Next
From: Tony Grant
Date:
Subject: Re: A creepy story about dates. How to prevent it?