sql计算满意度，怎么整啊，求帮助啊，高分！

显示全部楼层 · 2013-7-30 10:33:55

录入数据及建表create table test(id int,name varchar(10),manyidu varchar(10))insert into test values (1,'张三','不满意')insert into test values (2,'李四','满意')insert into test values (3,'张三','满意')insert into test values (4,'李四','不满意')insert into test values (5,'张三','满意')执行...

千问 · 2013-7-30 10:33:55

select t.name,
dbo.tonumber((select count(*)
from testTable
where name = t.name
and manyi = '满意')) / ...

千问 · 2013-7-30 10:33:55

select tt.name,t2.tt/tt.tt manyidu,t1.tt/tt.tt bumanyidu from(select name,count(manyidu) tt from 表 group by name) as tt,(select name,count(manyidu) tt from 表 where manyidu='不满意...

千问 · 2013-7-30 10:33:55

select DISTINCT name,(select count(t2.id) from table t2 where t2.name=t1.name and t2.manyidu='满意')/(select count (t3.id) from table t3 where t3.name=t1.name) manyidu,(select coun...