sqlÓï¾äµÄÒÉ»ó

SQL code:
select Hinge,count(Hinge) as HingeCount from dbo.Question where HingeCount>5 group by Hinge order by HingeCount desc


ÆäÖÐHingeCount>5ÕâÑùдΪʲô²»ÐУ¬ÌáʾHingeCountÎÞЧ

---

SQL code:
select Hinge,count(Hinge) as HingeCount from dbo.Question
group by Hinge having(count(Hinge))>5 order by HingeCount desc

---

SQL code:
select Hinge,
count(Hinge) as HingeCount
from dbo.Question
group by Hinge
having count(Hinge)>5

---

ÒòΪÄãµÄÄǸöHingeCountÊDZðÃû

---

SQL code:
--還ÊÇ
select * from(
select Hinge,
count(Hinge) as HingeCount
from dbo.Question group by Hinge )t

where HingeCount>5 order by HingeCount desc

---

SQLÂß¼­´¦Àí˳Ðò
SQL code:
(8) SELECT (9) DISTINCT (11) <TOP_specification> <select_list>
(1) from <left_table>
(3) <join_type> JOIN <right_table>
(2)