Hello Martijn,
Tuesday, June 24, 2003, 12:32:53 PM, you wrote:
MvO> On Tue, Jun 24, 2003 at 12:16:43PM +0200, Uros wrote:
MvO> How about:
MvO> Duplicate urls would be given by:
MvO> select url from directory group by url having count(*) > 1;
MvO> To get all the entries with those urls, something like:
MvO> select id,url,title from directory,
MvO> (select url from directory group by url having count(*) > 1) as list
MvO> where list.url = directory.url;
MvO> I hope I got the syntax right.
I tried that before but got error:
ERROR: Column reference "url" is ambiguous
--
Best regards,
Uros mailto:uros(at)sir-mag(dot)com