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 "18.104.22.168 Counting rows".
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