Re: Results Rank

tml > > J.R. > > -Original Message- > From: jakot05 [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 11, 2006 12:37 PM > To: mysql@lists.mysql.com > Subject: Results Rank > > Hi! > > I have a table like this > > > names > ··

Results Rank

Hi! I have a table like this names ··· john peter mary peter john peter mike mary mary mary ··· I want to get a list ordered by the number of times the name appears in the table, in the example: mary peter john mike How I can do this?...thanks a lot for the