| List: | General Discussion | « Previous MessageNext Message » | |
| From: | abhishek jain | Date: | May 9 2011 12:15pm |
| Subject: | Deleting the duplicate values in a column | ||
| View as plain text | |||
hi,
If we have a following mysql table:
Name - ids
A 1
B 1
C 2
D 3
I want to remove all duplicate occurances and have a result like
Name - ids
C 2
D 3
how can i do that with a query in mysql
Pl. help asap
--
Thanks and kind Regards,
Abhishek jain
| Thread | ||
|---|---|---|
| • Deleting the duplicate values in a column | abhishek jain | 9 May |
| • Re: Deleting the duplicate values in a column | Aveek Misra | 9 May |
| • Re: Deleting the duplicate values in a column | Aveek Misra | 9 May |
