sql语句求助

[li98350]

OleDbDataAdapter1.SelectCommand.CommandText = "select '" & zm(i) & "' as 发站,'" & zm(j) & "' as 到站,sum(rs) as 人数 from rs where year(rq)='" & Year(TextBox1.Text) & "' and month(rq)='" & Month(TextBox1.Text) & "' and cc=" & dqcc & " and fz='" & zm(i) & "' And dz ='" & zm(j) & "'"
返回的结果有很多sum(rs)为null的，想去掉，在sql的where子句里怎么实现？

[neodotnet]

WHERE rs <> 0

将rs字段默认值设为0

[canyqf]

OleDbDataAdapter1.SelectCommand.CommandText = "select '" & zm(i) & "' as 发站,'" & zm(j) & "' as 到站,sum(rs) as 人数 from rs where year(rq)='" & Year(TextBox1.Text) & "' and month(rq)='" & Month(TextBox1.Text) & "' and cc=" & dqcc & " and fz='" & zm(i) & "' And dz ='" & zm(j) & "' AND rs NOT IS NULL"

[li98350]

第一位大哥 hiyejpgd(叶金平在广东) 的回复完全正确，谢谢大哥，区区20分不成敬意！

[Brunhild]

这是我对一个ACCESS数据库的查询，看对你有没有用：

select 产品名称, sum(数量) as total from 新品输入 group by 产品名称 having not isnull(sum(数量))

[hiyejpgd]

OleDbDataAdapter1.SelectCommand.CommandText = " select * from ( select '" & zm(i) & "' as 发站,'" & zm(j) & "' as 到站,sum(rs) as 人数 from rs where year(rq)='" & Year(TextBox1.Text) & "' and month(rq)='" & Month(TextBox1.Text) & "' and cc=" & dqcc & " and fz='" & zm(i) & "' And dz ='" & zm(j) & "') a where not a.人數 is null"