SQL Aggregate Functions: Essential Guide with Tips for Newbies
Other SQL Aggregate Functions for Counting. COUNT returns an INT data type. If you need to count big data sets up to 9,223,372,036,854,775,807, then COUNT won''t work. You need COUNT_BIG. It returns a BIGINT data type suited for counting very large data sets. It functions the same as COUNT, but the difference is in the type of data returned.