Dear Xperts

How can we delete duplicate rows from a table.
For Eg.
ColA ColB ColC ColD
A01 XYZ 20 500
A01 XYZ 20 500

Thanks In Advance



*********************************************
This communication which may be confidential and privileged and the
views expressed herein may be personal and are not necessarily the
views of Coats plc. It is for the exclusive use of the intended
recipients(s). If you are not the intended recipient(s), please note that
any distribution, copying or use of this communication or the information
in it is strictly prohibited. If you have received this communication in
error, please notify us by email (Apps.[Email address protected] or telephone
our technical support helpdesk at Coats plc. +44 (0)20 8210 5100
(UK 0830h - 1800h, Mon-Fri, GMT) and then delete the e-mail and
any copies of it.
**********************************************


MS Sql Server LazyDBA home page