Search results

Hi, Currently I'm having 5 Million records and trying to get the result from below query SELECT * FROM AT_OUTBOUND_062017 WHERE CALLING_NBR LIKE in (201009, 201025, 207259, 2610012, 2611125, 2611914, 2613188, 2615500) Getting Syntax error (missing operator) in query expression 'CALLING_NBR...

Hi, I'm facing format issue on access, For instance: I have a table like this (around 9 million records) Column "F3" considered as long text as raw data itself in same format. F1 F2 F3 F4 708807945...

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...