运行sql时出现多个空值，如何去除

1、创建测试表，

create table test_null(work_no VARCHAR(20), chi荏鱿胫协nese_name varchar2(20), department_name varchar2(20), department_id varchar2(20), fee varchar2(20));

2、插入测试数据

insert into test_null values(null,null,null,null,'5.00');

insert into test_null values(null,null,null,null,'17.00');

insert into test_null values(null,null,null,null,'29.50');

insert into test_null values(null,null,null,null,'52.00');

insert into test_null values(321269,'梁XX','外销','WX','5.00');

3、查询原始表的记录，select t.*, rowid from test_null t ，有很多字段值为空的记录，

4、编写sql，限定条件，过滤掉字段为null的记录，

select t.*

from test_null t

where work_no is not null

and chinese_name is not null

and department_name is not null

and department_id is not null，