查询某个值为空或者不为空

select * from TABLE where X is not NULL;
select * from TABLE where X is NULL;