Re: !! URGENT - need Help !!

Won't this SQL only remove one copy and not all?

--
Alan D. Mills

dvsingh1_at_my-dejanews.com wrote in message <6vsg61$fd2$1_at_nnrp1.dejanews.com>...
>Hi..
> Simply run this query to remove the duplicae entries......
>
> delete from <table_name>
> where rowid IN ( select MIN(ROWID) from <tabe_name>
> group by <field_names>
> having count(*)>1);
>
Received on Mon Oct 12 1998 - 05:49:28 CDT