sql中的非空判断语句
求个sql判断非空的语句;
类似select Group_ID,Group_Name from T_CD_Group where Group_ID isnot null
但不是isnot .具体忘了 .
[解决办法]
select Group_ID,Group_Name from T_CD_Group where Group_ID is not null
[解决办法]
判断:
is not null
is null
赋值:
=null
[解决办法]
select Group_ID,Group_Name from T_CD_Group where Group_ID is not null