--sum等计算函数会自动过滤空值
create table test_a
(a number)
insert into test_a(a)values(1);
insert into test_a(a)values(null);
select * from test_a;
select sum(a) from test_a
--sum等计算函数会自动过滤空值
create table test_a
(a number)
insert into test_a(a)values(1);
insert into test_a(a)values(null);
select * from test_a;
select sum(a) from test_a