Hello Hervé,
Thanks a lot for help. Both Martijn van Oosterhout and yours do job god.
Execution time is now about 1 to 2 seconds. I also figured myself what i
was doing wrong with join and error i got.
If enybody need this here is both three solutions.
select distinct d1.id,d1.url,d1.title from
Hi,
I think this could be good :
select d1.id, d1.url, d1.tittle
from directory d1
where exists (select url from directory d2 where d1.url=d2.url and
d2.oid>d1.oid)
order by d1.url;
Hope this will help,
Regards,
Le Mardi 24 Juin 2003 12:16, Uros a écrit :
> Hello ,
>
> I have table dir
On Tue, Jun 24, 2003 at 01:12:05PM +0200, Uros wrote:
> Hello Martijn,
>
> 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
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, someth
On Tue, Jun 24, 2003 at 12:16:43PM +0200, Uros wrote:
> Hello ,
>
> I have table directory with 3 columns (id,url,title)
>
> I want to list all entries with duplicate urls.
>
> I tried this:
>
> select id,url,title from directory where url IN
> (select url from directory group by url having c
Uros wrote:
(B>
(B> I want to list all entries with duplicate urls.
(B>
(B> I tried this:
(B>
(B> select id,url,title from directory where url IN
(B> (select url from directory group by url having count(url) > 1)
(B> ORDER by url;
(B
(BTry:
(B
(Bselect id,url,title from directory w
Hello ,
I have table directory with 3 columns (id,url,title)
I want to list all entries with duplicate urls.
I tried this:
select id,url,title from directory where url IN
(select url from directory group by url having count(url) > 1)
ORDER by url;
but this takes 30 seconds with 25.000 entrie
