Select from following answers:- Count()
- COUNT_BIG ()
- Max()
- 1) and 2)
- All Above
The COUNT_BIG function is identical to the COUNT function, but returns a BIGINT data type, whereas COUNT returns an INT. The upper limit for INT data type is 2 billion; therefore if you anticipate counting more than two billion rows use the COUNT_BIG function. Any attempt to use the COUNT function when counting over 2 billion rows returns an error.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator