List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:August 20 1999 2:19pm
Subject:Re: count unique items
View as plain text  
On Fri, 1999-08-20 10:10:20 -0400, Stuart D Jackson wrote:
> 	Sorry if this has been asked already.  I have a table of records,
> and one of the columns is department.  What I need to do is output a list
> of departments and a count of how many records correspond to each
> department.  Any suggestions would be great.  Thanks a lot.

The MySQL manual has a tutorial on SQL, worth a read!
For your problem see chapter "8.3.4.8 Counting rows".

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
count unique itemsStuart D Jackson20 Aug
  • Re: count unique itemsMartin Ramsch20 Aug
Re: count unique itemsPinkeshP20 Aug