发布网友 发布时间:2022-04-08 07:18
共2个回答
懂视网 时间:2022-04-08 11:39
SELECT GoodID,sum(if(Level = 1, 1, 0)) as Better,sum(if(Level = 0, 1, 0)) as Nomal,sum(if(Level = -1, 1, 0)) as Bad from evaluates GROUP BY GoodID;
MySQL查询某个字段为某值的次数统计SQL语句
标签:
热心网友 时间:2022-04-08 08:47
select name,count(*) as 人次追答人次只是我起的别名,就是你的最后一列