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.

cheers,

-- 
Marc Antony Vose
http://www.suzerain.com/

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