The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
- 1 Answers
- 1082 Views
- I also Faced
- E-Mail Answers
Answer Posted / Jitender Kumar Yadav
If the result of using the count() function in a database query exceeds the maximum integer limit, you can use bigint or decimal data types instead. You can also consider breaking down your query into smaller parts and combining the results to avoid the issue.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
