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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org