js typed this on 01/30/2004 10:07 AM:
i want to know what i can use to count the number of times a value
appears in a column listing where different values are listed. for
example, say in the column of Favorite Number we have 100 students,
and for each student his or her own row. and each student can pick a
number from 1-10. So, we have a column of 100 rows and each field can
contain either 1-10.    Now, i want to know how can i count the
number of times  lets say the #2 appears in this list and give that
count a number. so if #2 appears 43 times in that column, then i want
it to say "2 is listed 43 times."  how do i do this? thank you for
your help with my beginner newbie questions. -james

If your table was like this (in postgresql in this example):

CREATE TABLE student_numbers (
  id SERIAL,
  student_id int,
  fav_num int

Now I have inserted in 9 rows of student id's and favorite numbers.

# SELECT fav_num as "Favorite Number", count(*) FROM student_number GROUP BY fav_num;

 Favorite Number | count
               1 |     1
               2 |     3
               3 |     1
               5 |     3
               7 |     1


Robby Russell

-- #------------------------------------------------------- # Robby Russell, | Sr. Administrator / Lead Programmer # Command Prompt, Inc. | http://www.commandprompt.com # [EMAIL PROTECTED] | Telephone: (503) 667.4564 #-------------------------------------------------------

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to