ÇóÒ»¾äSQLÓï¾ä

ÔÚÒ»¸ö±íΪ£ºtb_a
×ֶΣº
id  overnum  status  Style
1    2        ok      a
1    2        ok      a
1    2        ok      a
1    8        ok      b
1    9        ok      b
...
ÓÃÒ»ÌõÓï¾ä¸ù¾ÝStyleµÄ²»Í¬²éѯÔÚStyleΪaʱ£¬overnumµÄ×ܺͼ°StyleΪbʱµÄ×ܺÍ,ÓÃÒ»ÌõÓï¾ä¿ÉÒÔÂð£¿
Òâ˼Ϊ£º½«ÒÔÏÂÁ½¾äºÏ²¢
1.select sum(overnum) as count1 where Style='a' and status='ok'
2.select sum(overnum) as count2 where Style='b' and status='ok'

---

1.select sum(overnum) as count1 from tb_a where Style='a' and status='ok'
2.select sum(overnum) as count2 from tb_a where Style='b' and status='ok'

---

SQL code:
SELECT STYLE,
SUM(CASE WHEN STYLE='A' THEN overnum ELSE 0 END)AS COUNT1,
SUM(CASE WHEN STYLE='B' THEN overnum ELSE 0 END)AS COUNT2
from TB WHERE status='ok' GROUP BY STYLE

---

select (1.select sum(overnum) as count1 where Style='a' and status='ok'),(select sum(overnum) as count2 where Style='b' and status='ok')

---

SQL code
{{----