My query used to be SELECT PROVIDER, LEFT([START_TIME],13) as [HOUR], DEVICE_ID as BIKEID FROM table1 GROUP BY PROVIDER_NAME, DEVICE_ID, LEFT([START_TIME],13) and it was …
My query used to be SELECT PROVIDER, LEFT([START_TIME],13) as [HOUR], DEVICE_ID as BIKEID FROM table1 GROUP BY PROVIDER_NAME, DEVICE_ID, LEFT([START_TIME],13) and it was …