select * from "StudentMaster" where "PhoneNo" = NULL;
语法错误!
我想查看所有没有电话号码的记录!
我已经尝试了这一切。
select * from "StudentMaster" where "PhoneNo" NOT LIKE ('%');
select * from "StudentMaster" where "PhoneNo" NOT IN ('%');
但它显示了所有有电话号码但不为空的记录!为什么
select * from "StudentMaster" where "PhoneNo" = NULL;
语法错误!
我想查看所有没有电话号码的记录!
我已经尝试了这一切。
select * from "StudentMaster" where "PhoneNo" NOT LIKE ('%');
select * from "StudentMaster" where "PhoneNo" NOT IN ('%');
但它显示了所有有电话号码但不为空的记录!为什么