SQL COUNT overflow

Question

Here is my query:

SELECT COUNT(*) FROM Similarities WHERE T1Similarity = 0 OR T2Similarity = 0

Here is the result:

Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression to data type int.

The table has 4 billion rows. I don't expect this query to be fast, but after about 5mins, it fails with an overflow error. Is there a COUNT function for bigger data than int?

Thanks.

pstrjds · Accepted Answer · 2011-04-13 02:04:56Z

175

Use COUNT_BIG

SELECT COUNT_BIG(*) FROM Similarities WHERE T1Similarity = 0 OR T2Similarity = 0

answered Apr 13, 2011 at 2:04

pstrjds

17.6k7 gold badges54 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sanjeevakumar Hiremath · Accepted Answer · 2011-04-13 02:05:21Z

29

 SELECT COUNT_BIG(*) FROM Similarities WHERE T1Similarity = 0 OR T2Similarity = 0

answered Apr 13, 2011 at 2:05

Sanjeevakumar Hiremath

11.3k3 gold badges43 silver badges46 bronze badges

1 Comment

Gene Burinsky Over a year ago

I get this answer was posted 1 minute after pstrjds posted theirs, but they're completely identical. Do we need this?

Collectives™ on Stack Overflow

SQL COUNT overflow

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related