SQLè¯å¥æ¥å¤ææ°æ®åºæä¸åä¸æ¯å¦æç¸åå¼çè®°å½æ¹æ³
æçæ¶åæ们å¯è½éè¦å¤ææ°æ®åºä¸ï¼æä¸å段ï¼æä¸åï¼ä¸æ¯å¦æç¸åå¼çè®°å½ï¼è¿æ¶è¯¥æä¹åå¢ï¼æ ¹æ®æ¨æ使ç¨çæ°æ®åºä¸åï¼é¦å
ä½ è¦æå¼æ°æ®åºçæ¥è¯¢çªå£ï¼éè¿SQLè¯å¥æ¥å建æ¥è¯¢ï¼ç¶åè¿è¡å°±å¯ä»¥äºï¼å
·ä½æ¹æ³å¦ä¸ï¼
è¿éå设æ°æ®åºä¸æä¸ä¸ªå为studentç表ï¼æè¦æ¥è¯¢çå段æ¯nameï¼åå¤æstudent表ä¸nameå段ä¸æ¯å¦æç¸åå¼çè®°å½çSQLè¯å¥ä¸ºï¼
1ãæ¥è¯¢åºæ°æ®åºä¸æ»çnameå段记å½æ°çå¼
SELECT COUNT(name)
FROM student
2ãæ¥è¯¢åºæ°æ®åºä¸nameå段ä¸å¯ä¸çè®°å½æ»æ°ï¼å³æ¥è¯¢åºä¸ç¸åçè®°å½æ°ï¼å¦ææ¾å°ç¸åçè®°å½ååå
¶ä¸ä¸æ¡è®°å½ï¼
SELECT COUNT(name)
FROM student
GROUP BY name
æ¯è¾ä¸é¢ä¸¤æ¬¡æ¥è¯¢çç»æï¼å¦æä¸æ ·ï¼å表æstudentæ°æ®åºä¸çnameå段ä¸å¹¶æ²¡æç¸åå¼çè®°å½ï¼å¦æä¸ä¸æ ·ï¼å表æstudentæ°æ®åºä¸çnameå段ä¸æç¸åå¼çè®°å½ã