因为要做一个调查系统,所以需要检索出每个选项被选择的次数
所以用以下语句获得了结果非常感谢雄哥。。哈哈
SELECT Count(answer)as Sum,answer FROM Favorites where Qid=1 GROUP BY answer
Sum answer
1 7 a
2 8 b
3 5 c
4 6 d
因为要做一个调查系统,所以需要检索出每个选项被选择的次数
所以用以下语句获得了结果非常感谢雄哥。。哈哈
SELECT Count(answer)as Sum,answer FROM Favorites where Qid=1 GROUP BY answer
Sum answer
1 7 a
2 8 b
3 5 c
4 6 d