sivaksekar
New member
- Local time
- Tomorrow, 01:49
- Joined
- Aug 29, 2017
- Messages
- 4
Hi,
Currently I'm having 5 Million records and trying to get the result from below query
SELECT FORMAT (START_TIME, "MM/DD/YYYY") AS CALLDATE, COUNT(CALLING_NBR) AS TOTAL_CALLINGNUMBER, COUNT(CALLED_NBR) AS TOTAL_CALLEDNUMBER, SUM(DURATION) AS TOTAL_DURATION
FROM [Salaam to AWCC outgoing May 2016]
GROUP BY FORMAT (START_TIME, "MM/DD/YYYY");
Usually i ll get the result from this query..
This time continuously getting "over flow" message..
Kindly ride off this msg to get the expected result.
Regards,
Siva
Currently I'm having 5 Million records and trying to get the result from below query
SELECT FORMAT (START_TIME, "MM/DD/YYYY") AS CALLDATE, COUNT(CALLING_NBR) AS TOTAL_CALLINGNUMBER, COUNT(CALLED_NBR) AS TOTAL_CALLEDNUMBER, SUM(DURATION) AS TOTAL_DURATION
FROM [Salaam to AWCC outgoing May 2016]
GROUP BY FORMAT (START_TIME, "MM/DD/YYYY");
Usually i ll get the result from this query..
This time continuously getting "over flow" message..
Kindly ride off this msg to get the expected result.
Regards,
Siva