COUNT_BIG (TSQL Function)
Returns the count of the column values.
It is exactly the same as COUNT
, except that it always returns bigint
.
Syntax
COUNT_BIG ( expression )
COUNT_BIG ( * )
Arguments
- expression
- is an expression of any type.
Return Types
Returns bigint
.
Remarks
NULL values in the expression are ignored.
COUNT_BIG(*)
counts all expressions, including NULL values.
Examples
DECLARE @t TABLE (
id INT NOT NULL PRIMARY KEY,
name VARCHAR(30),
birthdate DATE,
children TINYINT
);
INSERT INTO @t VALUES (10, 'John', '19700301', 1),
(20, 'Fred', '20021123', NULL),
(40, 'Alex', '19950712', 2),
(50, 'Maria', '19700322', 0),
(30, 'Alice', '19950101', NULL),
(15, NULL, '19950101', 5);
SELECT YEAR(birthdate), SUM(children), COUNT_BIG(*), COUNT_BIG(children)
FROM @t
GROUP BY YEAR(birthdate)
ORDER BY YEAR(birthdate);
The result is:
$g$0 |$sum$1 |$count$2 |$count$3 |
-----------+--------------------+-----------+-----------+
1970| 1| 2| 2|
1995| 7| 3| 2|
2002| <NULL>| 1| 0|
(3 row(s) affected)