• hi, I usually have the following scenario: I have to count the distincts names

    for this I use:

    SELECT COUNT(distinct name) AS [COUNT distinct] FROM [CountTest];