From: abhishek jain
Date: May 9 2011 12:15pm
Subject: Deleting the duplicate values in a column
List-Archive: http://lists.mysql.com/mysql/224973
Message-Id: <BANLkTink5cWEJWKBAomYVP3j6spmqY+OFw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=000e0ce0b492f02eae04a2d6c94a

--000e0ce0b492f02eae04a2d6c94a
Content-Type: text/plain; charset=ISO-8859-1

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

--000e0ce0b492f02eae04a2d6c94a--