Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
It's easy to create a query from a DB as below.
select 1
union
select 2
union
select NULL
Let's say the above column name is ID, then you do count and count(distinct) for ID. It will show as this one.
COUNT(DISTINCT) | Count |
3 | 2 |
It's wrong as NULL should not be counted in results. So could you please check and fix this issue? Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.