Tag: ssms-2014

group by with multiple columns and with condition

sql ssms-2014

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 …