Sql count distinct include null

Newsletter Topics Select minimum 1 topic. Big Data. Ranjan80 Posted June 3, 0 Comments. Terence Curran Posted June 3, 0 Comments. Naganathavanthian Chellam Posted June 4, 0 Comments. I guess count distinct[doc id] will not include the null values….. Regards Nag. Register or Login. The Basics. The Good Stuff. Using Globals. First Look. Using SQL. Optimizing SQL. Document Database. XML Tools.

XML Projections. Web Services. Web Gateway Configuration Guide. Using JSON. Internet Utilities. Advanced Concepts. Unit Testing Overview. What is a Unit Test? Why Unit Test? API Index. Tools Index. Complete Glossary of Terms.

External Language Development. Using Java with InterSystems Software. Native API for. NET Managed Provider. Using the Native SDK for.

NET Quick Reference. Interoperability Productions. First Look Introducing Interoperability Productions. Preparing to Create Productions. Best Practices. Developing Productions. Developing Productions Using ObjectScript. Developing Productions Using Java and.

Developing DTL Transformations. Using a Production as an ESB. Configuring, Managing, and Monitoring Productions. Configuring Productions. If you want to know how many unique values are in Col1, you might write something like this:. Two distinct values great! If we want to see the actual values instead of just seeing the count:.

Doing that will produce a count and count distinct that is consistent with SQL Server. Just keep in mind what level you're filtering that data at as that might cause other problems if not fully accounted for. I will consult this issue internally and post back here once I get any updates. As a result, most users are going to expect count distinct to work in an industry standard way. Count distinct seems consistently to count the null value which other systems do not - and as a result, users won't expect.

Power BI. Turn on suggestions. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for. Search instead for. Did you mean:.