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 columnabhishek jain9 May
  • Re: Deleting the duplicate values in a columnAveek Misra9 May
    • Re: Deleting the duplicate values in a columnAveek Misra9 May