How do I delete duplicate records in a table which doesnot have any identity colum in a single query
pls help

Manivannan,
not really a replication topic :-) (if you haven't done this already, then
consider posting this in the programming group). Hovever, please can you
reply (here or in the other group) with a table schema and some sample rows
which represent the duplicates and normal rows. What you are asking is a
general problem for which there are solutions providing there is entity
entegrity, but a script will make it easier to arrive at a working solution.
Cheers,
Paul Ibison