Ò»¸öSQL²éѯÎÊÌâ

±í×Ö¶Î
Answerid    Questionid    NAME        sort
1            2            test1      4
2            1            test1      5
3            1            test2      1
4            2            test2      3
5            5            test2      6
6            7            test2      2


ÎÒҪͳ¼Æ NAME=test2 µÄQuestionid£¬°´ÕÕsortÅÅÐò£¬²¢ÇÒ»¹Òªcount(Answerid)
ÎҵIJéѯÓï¾äÊÇ£º
SELECT COUNT(Answerid) AS Counts, Questionid
from t
WHERE  (Questionid IN(SELECT Questionid from t WHERE (NAME = 'test2')))
GROUP BY Questionid

Êý¾ÝÊÇÄܲéѯ³öÀ´£¬µ«ÊÇÎÒ²»ÖªµÀ¸ÃÔõôÓÃsort½øÐÐÅÅÐò£¬Çó¸ßÊÖ½â´ð¡«¡«

---

SQL code:
SELECT COUNT(Answerid) AS Counts, Questionid
from t
WHERE NAME = 'test2' GROUP BY Questionid ORDER BY sort
?