select count(distinct a,b,c) from (
select null as a,1 as b,1 as c
union all
select 1,2,1
union all
select null,3,1
union all
select null,4,1
union all
select null,5,1
union all
select null,6,1
) a
将null换成其他值
select count(distinct nvl(a,0),b,c) from (
select null as a,1 as b,1 as c
union all
select 1,2,1
union all
select null,3,1
union all
select null,4,1
union all
select null,5,1
union all
select null,6,1
) a