SQL每日一题(20210408)即只取状态为FULL的DOCNUM，如果有同时为NOFULL的DOCNUM则不取。

SQL每日一题(20210721)
SQL每日一题(20211015)
SQL每日一题(20220411)

select DOCNUM from T0408 where DOCNUM not in (
select distinct(DOCNUM) from T0408 where  STATUS  = 'NOFULL')

SELECT DOCNUM
FROM T0408 AS T
WHERE NOT EXISTS(SELECT DOCNUM FROM T0408 WHERE STATUS = 'NOFULL' AND DOCNUM = T.DOCNUM)

select f.docnum
from (select e.*, count(1) over (partition by e.docnum) rn from t0408 e) f
where rn = 1
  and f.status = 'FULL';

select *
from t0408 e
where e.docnum in (select f.id from (select e.docnum id, count(*) sl from t0408 e group by e.docnum) f where sl = 1)
  and e.status = 'FULL'