发个帖子记录一下sql语句cha询列不同值计数

urenai

1. select [字段] as '值',count(*) as '个数' from [表名] Group by [字段]

复制代码

用以统计不同值的数量。