Hi Everybody,

How to delete the duplicate values from the columns except one. For Eg. if the name of the table is "emp" with only one field "empname" of type varchar. This field has got four values all of which are duplicate. Eg. "samir" "samir" "samir" "samir"

What I want is to delete 3 records and keep only one value. How do I achieve that?

Regards,

Samir.