Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2009

    Unanswered: select certain rows

    I currently have a db with the fields like this:
    db name:Table
    user answers
    a 1
    b 1
    c 2
    d 2
    e 3

    how do i select all the columns in the answers that has more than one same values? for example, i want to only select the rows a,b,c,d because their answers have multiple values (1, 2). then i want to group them and count
    the number of rows for each group. so in the end, the echo statement should say 2 because a,b is grouped as one and c,d is another group. is it something like:

    SELECT answers, COUNT(answers) FROM Table WHERE COUNT(answers)=2 GROUP BY answers ";
    $result = mysql_query($query) or die(mysql_error());
    $a = mysql_fetch_array($result);
    echo "$a";

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    SELECT answers, COUNT(answers) FROM Table GROUP BY answers HAVING COUNT(answers)=2 | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts