求教一个sql的问题！

[yixiaoyi2009]

select stu_id from (
select stu_id,
SUM(item1)-Count(Item1)*Min(Item1) as r1,
SUM(item2)-Count(Item2)*Min(Item2) as r2,
SUM(item3)-Count(Item3)*Min(Item3) as r3,
SUM(item4)-Count(Item4)*Min(Item4) as r4,
SUM(item5)-Count(Item5)*Min(Item5) as r5,
SUM(item6)-Count(Item6)*Min(Item6) as r6
from (select e.*,c.Course_Type from eval_result e inner join course_Teach c on e.courseTeach_id = c.courseTeach_id) as table1 group by stu_id
) as table2
where r1 = 0 or r2 =0 or r3 = 0 or r4 =0 or r5 =0 or r6 =0

在以上的sql语句中，如何先判断item1到item6中的值是否等于0呢？
也就是说，执行“SUM(item1)-Count(Item1)*Min(Item1) as r1”之前，如何知道SUM(item1)不为0，如果为0，就不执行！

[王向飞]

你这么写没问题啊

[dawugui]

最好给出完整的表结构,测试数据,计算方法和正确结果.否则耽搁的是你宝贵的时间。
如果有多表,表之间如何关联?

发帖注意事项
http://topic.csdn.net/u/20091130/21/fb718680-98ff-4afb-98d8-cff2f8293ed5.html?24281

[Ny-6000]

使用case语句可行.

[luyuwei2008]

把要显示的结果写出来

[yixiaoyi2009]

显示的结果是id号，就是通过
SUM(item1)-Count(Item1)*Min(Item1) as r1,
SUM(item2)-Count(Item2)*Min(Item2) as r2,
SUM(item3)-Count(Item3)*Min(Item3) as r3,
SUM(item4)-Count(Item4)*Min(Item4) as r4,
SUM(item5)-Count(Item5)*Min(Item5) as r5,
SUM(item6)-Count(Item6)*Min(Item6) as r6
来判断是否为0，也就是将是0的值的id号显示出来