SELECT * from aa WHERE aa not in(2,3)
and aa not in(SELECT aa from aa where bb =1 and cc is null);
(SELECT * from aa where bb not in (1,2,3)) UNION all (SELECT * from aa where bb =1 and cc is not null )
原文：http://www.cnblogs.com/w8104254/p/4377664.html