Home Forums Article Discussions Article Discussions by Author Discuss content posted by Prakriti Agrawal COUNT_BIG RE: COUNT_BIG

  • March 9, 2010 at 6:57 am

    #1130624

    Explaination is a little off.

    COUNT_BIG(all column_2) will count all rows from the table (including duplicate & null rows).

    I think you meant count_big(*). COUNT_BIG(all column_2) will not count the NULLs.