山东最好肝胆医院排名:ASP字段非空如何编码?

来源:百度文库 编辑:高考问答 时间:2024/04/24 15:43:14
表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 <> ""