sql Óï¾ä

±í Table  ÁР A  ÁÐÖÐÓÐ ÀàÐÍ Îª1  Ϊ2  Ϊ3  .....

ÏÔʾÀàÐÍΪ 1 µÄºÏ¼Æ 2 µÄºÏ¼Æ 3 µÄºÏ¼Æ .....

ÏÔʾËùÓÐÀàÐÍ 1 2 3 ...

---

SQL code:
select count(ÀàÐÍ) from A group by ÀàÐÍ


£¿£¿

---

group by a with cube

---

SQL code:
SELECT SUM(A) from TB GROUP BY A
??

---

ÏÔʾËùÓеÄÀàÐÍ

---

Äܸø³öÊý¾ÝÂð£¿

---

´ó¸ç´ó½ã  ÀàÐÍÓÐ ºÃ¼¸°ÙÖÖ

---

ÒýÓÃ

ÏÔʾËùÓеÄÀàÐÍ

¸ø³ö±í½á¹¹
²âÊÔÊý¾Ý
¼°Æä½á¹û

---

ÃèÊöµÄÌ«º¬ºýÁË

---

ÒýÓÃ

SQL codeselectsum(casewhen A=1then1else0end)'A',sum(casewhen A=2then1else0end)'B',sum(casewhen A=3then1else0end)'C'fromtable

¶¥4Â¥µÄ

---

ok ÎÒ´«Í¼

---

Êý¾Ý,½á¹¹,·½·¨ºÍ½á¹û.

---

»¹ÊDz»Ã÷°×Â¥Ö÷Ҫʲô£¿£¡

---

en    ok  ÁË Ð»Ð»´ó¼ÒÁË

---

ÒýÓÃ

en    ok  ÁË Ð»Ð»´ó¼ÒÁË

°¡
ÊÇÄǸöÂú×ãÄãµÄÒªÇó°¡

---

ÒýÓÃ

ÒýÓà 16 Â¥ svsstar µÄ»Ø¸´:
en    ok  ÁË Ð»Ð»´ó¼ÒÁË