sql = "select * from churukujilu where ISNOTNULL(chukudept) and chukudept <> '事务所' order by id desc";
或者
sql = "select * from churukujilu where chukudept ISNOTNULL and chukudept <> '事务所' order by id desc";
都会出错啊。这个应该怎么修改呢。
...全文
3144打赏收藏
postgresql中ISNOTNULL用法?
sql = "select * from churukujilu where ISNOTNULL(chukudept) and chukudept '事务所' order by id desc"; 或者 sql = "select * from churukujilu where chukudept ISNOTNULL and chukudept '事务所' order by id desc"; 都会出错啊。这个应该怎么修改呢。