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 2:48 am

    #1889551

    Just tried these out, and this:

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

    Actually returns 6. This is on SQL Server 2008.