pl⼀sql如何判断记录数为空

2025-02-25 11:58:27
推荐回答(2个)
回答1:

查询表a记录数:select count(1) from a;
查询表a字段c1是否有空值:select a.* from a where a.c1 is null;

回答2:

count(*) = 0