select distinct(col1,col2) should work.. Group by most certainly will... Select col1,col2 from table group by col1, col2.. Same thing
> Hello, > > The two columns of my table are name and city. I am trying to > do a list which contains only the different names. This can > be done this by distinct keyword. But all the same names > which have different cities also have to be included in my > list. So I can not do this with a distinct keyword. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]