Re: Deleting the duplicate values in a column

[Aveek Misra]

SELECT * from <table>  group by id having count = 1;

On May 9, 2011, at 5:45 PM, abhishek jain wrote:

> 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