-
delete duplicate values except one?
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|