Total query of data registered in a field

Navigation
1

I have a table where a country field is defined. I want to know how I can develop a query that shows me how many records I have for each country.

Example:

  

Brazil: 10 records from the USA: 5 records

    
asked by anonymous 27.04.2014 / 14:42

1 answer

7

Half empty but something like 

Select pais,count(*) qtd
From tabela
Group by pais
    
27.04.2014 / 15:35
Cloud9-Problem executing code PHP / Codeigniter error "Array to string conversion"