Question

sql怎么查询出一列中非空的值

Answer 1

空值数据: select count(*) from YourTable where YourColumnName is null
非空值数据: select count(*) from YourTable where YourColumnName is not null
sqlserver Oracle Access 都通用的！

Answer 2

select * from hnzj_user_info u where u.user_name is not null;

Answer 3

where isnull(a,"")<>"" MS SQL写法

Answer 4

where a is not null