Question

SQL COUNT一个表中特定字段出现的次数

比如表
UsingDay
Monday
Tuesday
Monday
Monday

希望得到结果：
Monday 3
Tuesday 1
即统计多个词在同一字段出现的次数
比如table pool.UsingDay有以下数据
Monday
Tuesday
Monday
Sunday

得到结果
Monday Tuesday Sunday
2 1 1

Answer 1

select UsingDay,count(UsingDay)
from table
group by UsingDay

select count(case UsingDay when 'Monday' then Monday else null end) as Monday
,count(case UsingDay when 'Tuesday' then Monday else null end) as Tuesday
,,count(case UsingDay when 'Sunday' then Monday else null end) as Sunday
from pool

Answer 2

select col,count(*) from tablename group by col;

Answer 3

yiyishuitian | 五级 同意他的