-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi Surabhi, search the archives, this has been discussed quite a few times in the pass. regards, - ----- Jonel Rienton http://blogs.road14.com Software Developer, *nix Advocate On Feb 8, 2005, at 11:44 AM, Surabhi Ahuja wrote: > i have a table in which duplicate rows occur. > Â > now i have to remove the duplicates. Please note that however, only > the duplicate rows have to be deleted and not the original one. > Â > How do i do it? -----BEGIN PGP SIGNATURE----- Version: PGP 8.1 iQA/AwUBQgjvDeAwOVAnbsGCEQKiwgCgn0JzdJKYXMq3WgeskWTKmg6xCUMAnRz9 +gfpmg4HI+PZPMU+KQcKPuLY =6189 -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster