MSSQL›Aggregate Functions›COUNT_BIG
←COUNT

COUNT_BIGAggregate Functions

SUM→

Returns the row count as BIGINT.

Syntax

COUNT_BIG(expr)

Example

Enter values below to update the example in real time.

total_rows→
large_log_table→
SELECT COUNT_BIG(*) AS total_rows FROM large_log_table;