Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.