select * from TABLE_NAME where COLUMN_NAME is null
select * from TABLE_NAME where COLUMN_NAME is not null