;with cet as(select * from tb 
except
select * from tb where 条件1 and 条件2 and 条件3 and ...)
select case when  条件1 then '' esle '条件1' end +
       case when  条件2 then '' esle '条件2' end +
...  as 缺少的条件 from cet