sql怎么查詢出一列中非空的值?
空值數(shù)據(jù): select count(*) from YourTable where YourColumnName is null非空值數(shù)據(jù): select count(*) from YourTable where YourColumnName is not nullsqlserver Oracle Access 都通用的!
sql怎么查詢出一列中非空的值?
空值數(shù)據(jù): select count(*) from YourTable where YourColumnName is null非空值數(shù)據(jù): select count(*) from YourTable where YourColumnName is not nullsqlserver Oracle Access 都通用的!