Microsoft SQL Sample Code

Using the APPROX_COUNT_DISTINCT Function

The builtin APPROX_COUNT_DISTINCT function returns the approximate number of unique non-null values in a group. The code below will show you how to use the APPROX_COUNT_DISTINCT function. For more details on the APPROX_COUNT_DISTINCT function click here

SELECT APPROX_COUNT_DISTINCT(Client_Number) As DistinctCount FROM CLIENT

If you need any help implementing this sql or modifications made for your needs, please Click Here to get a free quote for your Microsoft SQL Development needs. 

Click Here to learn more about the WSI quoting process.