Question

SQL语句怎么查询某列为空（空符合所有属性）和一列固定值的数据？？

select * from table_name where CSex='男' and CGrade is null and CLevel='部长'

Answer 1

select * from 表 where IsNull(某列)='' and 一列='固定值'参照我上边写~