Re: Easy way to remove duplicates from a table
From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: 13 May 2003 00:14:53 -0700
Message-ID: <1075eb85.0305122314.19270c2a_at_posting.google.com>
Date: 13 May 2003 00:14:53 -0700
Message-ID: <1075eb85.0305122314.19270c2a_at_posting.google.com>
dba_at_gobn.net (JasonF) wrote in message news:<aacfbe0.0305090617.7935d377_at_posting.google.com>...
> Here is an easy way to de-dupe a table. Union it against itself.
Hi,
do you try this some more rows, e.g. millions of rows ?
Sorry, don't see any advantages.
And what's about this
select distinct * from j;
same result, only one full table scan instead of 2 with the union.
Kay Received on Tue May 13 2003 - 09:14:53 CEST