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
- 1086 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
In which database can extended stored procedures be added?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Explain about the storage and physical database design?
How to combine two function together?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
agregator gives one to many records or many to one record
Write the fastest query to find out how many rows exist in a table?
Explain about network model?
Explain about relational database management systems?
How can you log an error to the server event log from a stored procedure?
Why does this query return 0?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
