Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dave M Distinct clause in Select statement RE: Distinct clause in Select statement

  • August 1, 2010 at 3:16 pm

    #1200794

    Carlo Romagnano (7/27/2010)

    Hugo Kornelis (7/26/2010)COUNT(*) returns the number of columns (regardless of values);

    That's false: COUNT(*) returns the number of ROWS regardless of of columns. :w00t:

    Yes, of course - I typed columns, but intended to write rows. Thanks for catching my mistake.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/