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:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
