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.