网页游戏自动挂机赚钱:ASP字段非空如何编码?
来源:百度文库 编辑:查人人中国名人网 时间:2024/05/22 05:08:34
表member中我想计算A字段非空的个数,请问怎么编码!
select count(id) from table where (not a isnull) and (a <>'')
select count(id) from table where (not a is null) and (a <>'')
SELECT COUNT(A) FOROM member WHERE a NOT ISNULL A <> ""