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