List:General Discussion« Previous MessageNext Message »
From:Aveek Misra Date:May 9 2011 2:24pm
Subject:Re: Deleting the duplicate values in a column
View as plain text  
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

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