List:General Discussion« Previous MessageNext Message »
From:Marc Antony Vose Date:July 23 2000 10:11pm
Subject:SQL question
View as plain text  
Hi there...

is there an way in mysql to select all the distinct items in a table 
and get a count of each?

this has me stumped.

i'd like output like:

United States | 150
Belgium | 25
UK | 15

and so on.


Marc Antony Vose

Into every tidy scheme for arranging the pattern of human life, it is 
necessary to inject a certain dose of anarchism.
-- Bertrand Russell
SQL questionMarc Antony Vose23 Jul
  • Re: SQL questionVan23 Jul