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 answers *** note: I don´t know wich are the names in the table, are changing all the time ***