SQL ·Ö×é²éѯÏÔʾÎÊÌâ

ÓÐ2Õűí Ò»ÕŹ«Ë¾±í Ò»ÕÅÔ±¹¤±í
ÎÒҪͳ¼Æ¹«Ë¾µÄÈËÊý
name ¹«Ë¾Ãû count ÈËÊý

¾ÍÕâ2ÁС£ÈçºÎͳ¼Æ£¿£¿Ð»Ð»

---

select name, count(name)  from  ±í group by name

---

sorry ´íÁË

---

ÒýÓÃ

select name, count(name)  from  ±í group by name

¶¥

---

´ó¸ç£¬ÎÒ¿´´íÌâÁË£¬Ð»Ð»

---

¶Ô¹«Ë¾±íºÍÔ±¹¤±í½¨Á¢¹ØÁªÊÓͼ
È»ºó select ¹«Ë¾Ãû,count(¹«Ë¾Ãû) as ÈËÊý from ÊÓͼ

---

ÉÏÃæµÄÉÙÁ˺ó°ë¾ä: group by ¹«Ë¾Ãû

---

ÉÏÃæµÄ¡£ÍòÒ»¹«Ë¾Ãû×ÖÓÐÖظ´ÁË¡£ÎÒ±ØÐëҪͨ¹ý¹«Ë¾id·Ö×é¡£

---

¶àл¥Éϵġ£3Q¡£

---

SQL code:
SELECT A.¹«Ë¾Ãû³Æ£¬ B.ÈËÊý
from ¹«Ë¾±í A
JOIN (SELECT ¹«Ë¾ID, COUNT(1) AS ÈËÊý from Ô±¹¤±í GROUP BY ¹«Ë¾ID) B
ON A.¹«Ë¾ID=B.¹«Ë¾ID

---

ÒýÓÃ

SQL codeSELECT A.NAMEAS ¹«Ë¾Ãû,COUNT(1)AS ÈËÊýfrom ¹«Ë¾±í A£¬ Ô±¹¤±í BWHERE A.¹«Ë¾ID= B.¹«Ë¾IDGROUPBY A.¹«Ë¾ID, A.¹«Ë¾Ãû

¶¥8Â¥  3Â¥¿´Çå³þÁËÔÙ¶¥  ÊÇ2Õűí

---

SELECT A.NAME AS ¹«Ë¾Ãû, COUNT(1) AS ÈËÊý
  from ¹«Ë¾±í A£¬ Ô±¹¤±í B
WHERE A.¹«Ë¾ID = B.¹«Ë¾ID
GROUP BY A.¹«Ë¾ID, A.¹«Ë¾Ãû