安卓台湾手游网:ASP字段非空如何编码?
来源:百度文库 编辑:中科新闻网 时间:2024/07/06 18:53:28
表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 <> ""