一列数据为，null 、 1、0 ，如查询closed 列 不为1的数据。谢谢[local]2[/local]

，截图文件

select * from 表1 where closed<>1 or closed is null

谢谢！！！！！

改后是这样
SQL("JDBC3", "SELECT  avg(VAL) FROM  " + $P1 + " WHERE (POINTID = 'YBPer1_tBlrMnStm_H.S') AND DUTYID = 3 AND CLOSED <>1 or  CLOSED is null AND DAY(ETIME)>=" + ($P3 - 10) + "  AND DAY(ETIME)<" + $P3, 1)

取值不对啊，哪错了，请帮助！！

select * from 表1 where closed<>1 or closed is null
是在SQL2000上运行的，你上面语句，是在那里运行的。

AND DUTYID = 3 AND CLOSED <>1 or  CLOSED is null AND
改为
AND DUTYID = 3 AND (CLOSED <>1 or  CLOSED is null) AND

我这个是统计满足条件的数据平均值，主要是WHERE 后面的部分，closed 列有1、0、和NULL。当为1时，不进行计算。CLOSED <>1 时少了为NULL部分数据，CLOSED is null 时少了为0部分的数据，
WHERE (POINTID = 'YBPer1_tBlrMnStm_H.S') AND DUTYID = 3 AND CLOSED <>1 or  CLOSED is null AND DAY(ETIME)>=" + ($P3 - 10) + "  AND DAY(ETIME)<" + $P3, 1)
(POINTID = 'YBPer1_tBlrMnStm_H.S') 为测点名，DUTYID为班组号，DAY(ETIME)>=" + ($P3 - 10) + "  AND DAY(ETIME)<" + $P3, 1)为日期范围，

谢谢！！！主要我太菜了！！

CLOSED <>1 or  CLOSED is null
这个条件是2者只要1个满足就可以，所以，当和其他的条件一起使用时，就要括号起来，重新组成1个条件，即
(CLOSED <>1 or  CLOSED is null)

select * from 表 where 条件1 and 条件2 and (CLOSED <>1 or  CLOSED is null) and 条件3