Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Multi-column grouping
It worked! I just had to make one small change - putting in the "as" keyword, as follows: mysql> select question, sum(case when response_text="TRUE" then 1 else 0 end) as yes, sum(case when response_text="FALSE" then 1 else 0 end) as no from response where question > 76 and question < 84 group... -
Multi-column grouping
That looks good! Thanks feherke; I'll give it a go. -
Multi-column grouping
Hi, I feel sure this should be possible, but can't quite figure it out. I have a database table that contains responses to a number of questions. Questions 77-83 are Yes/No questions, and I'd like to see, for each question, how many people answered yes and how many answered no. I can get the...
