get the most repeated data 1

[tuzojazz]

Hi:

suposse I have this table named "Employees"

Employees
-----------------------

Emloyee Country
-------------------------
John Italy
Geroge Germany
Steve Mexico
Jim Germany
Brian Germany
Richard Italy

I want to get the countries in order where are the most of the employees
------------
Germany
Italy
Mexico
----------

another example

Employees
-----------------------
Emloyee Country
-------------------------
Brian Germany
Geroge Mexico
John Italy
Steve Mexico
Jim Mexico
Richard Italy

I want to get this order

----------------
Mexico
Italy
Germany
---------------



how can I do this query?

Thanks!!

 

[Remou]

Do you mean:

[tt]SELECT Country
FROM tblTable
GROUP BY Country
ORDER BY Count(Country) DESC;[/tt]

 

[tuzojazz]

yeah!!

It works!!

Thanks my friend!