SQL计算语句请求问题

显示全部楼层 · 2012-12-22 15:55:26

使用下面写法就行了，其实把男生数和女生数的case when 相比就行了。SELECT Convert(VARCHAR(100), Zixrq, 23) AS 日期,
SUM(CASE WHEN Xingb = '女' THEN 1 ELSE 0 END) AS 女生数,
SUM(CASE WHEN Xingb = '男' THEN 1 ELSE 0 END) AS 男生数,
SUM(CASE WHEN Xingb = '男' THEN 1 ELSE 0 END) / SUM(CASE WHEN Xingb = '女' THEN 1 ELSE 0 END) AS 男女比例 FROM Huiyuan WHE...

千问 · 2012-12-22 15:55:26

你自己都写出来了，，再加个不就是了。select CONVERT(varchar(100), zixrq, 23) as 日期,sum(CASE WHEN xingb = '女' THEN 1 ELSE 0 END) as 女生数,sum(CASE WHEN xingb = '男'THEN 1 ELSE 0 END) as 男生数，sum...

千问 · 2012-12-22 15:55:26

加一列：（几倍，几比几，百分比分别如下）男生数/女生数 as 男女比例; 男生数||':'||女生数 as 男女比例;男生数/女生数*100||'%' as 男女比例;...

千问 · 2012-12-22 15:55:26

select (sum(CASE WHEN xingb = '女' THEN 1 ELSE 0 END)) girl_count as 女生数,select (sum(CASE WHEN xingb = '男'THEN 1 ELSE 0 END)) boy_count as 男生数select girl_count/boy_count a...