Re: [SQL ] table中分群做count
select date,count(case when value='a' then 1 else null end) as count_a,count(case when value='b' then 1 else null end) as count_b from table group by date
這樣應該可以達到你要的結果
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 36.230.158.63
※ 文章網址: https://www.ptt.cc/bbs/Database/M.1493902475.A.25B.html
推
05/04 21:23, , 1F
05/04 21:23, 1F
討論串 (同標題文章)