Viewing 2 posts - 1 through 2 (of 2 total)
I think that was needed !!!
regards
Vijendra...
March 12, 2004 at 5:39 am
#498476
Hi !
If the table structure is like.
Tbl1
(
pid integer,
.... some fields
)
then u can delete the duplicates as
delete from tbl1 where pid not in (select max(pid) from tbl1)
If u don;t...
March 11, 2004 at 9:02 pm
#498435