COUNT_BIG returns the number of items in the current SELECT statement. This includes NULL values and duplicates.

Remarks

Function works the same as COUNT() but returns a BIGINT as the return type. See the COUNT topic for more examples and information.

Example

SELECT COUNT_BIG(*) FROM table

SELECT COUNT_BIG(DISTINCT column) FROM table