Home Forums Article Discussions Article Discussions by Author Discuss content posted by Igor Micev The COUNT Function in T-SQL RE: The COUNT Function in T-SQL

  • July 12, 2016 at 3:53 am

    #1889553

    NParry (7/12/2016)

    Just tried these out, and this:

    /*(9)*/ SELECT DISTINCT(COUNT(1)) FROM #TmpCounts; -- 1 row

    Actually returns 6. This is on SQL Server 2008.

    6 is the result from the COUNT(1) and then DISTINCT(). Only 1 row is returned with a value 6.

    Igor Micev,My blog: www.igormicev.com