SELECT DATE,VRS_DEVICEID,LOCATION FROM
(
SELECT Row_number() over (
PARTITION BY SUBSTRING(CONVERT(VARCHAR(23), VRS_UTCTIME, 121),1,16) order by VRS_DEVICEID,'('+VRS_LATITUDE+', '+VRS_LONGITUDE+')' ) as rowno,
VRS_DEVICEID,'('+VRS_LATITUDE+', '+VRS_LONGITUDE+')' AS LOCATION,
SUBSTRING(CONVERT(VARCHAR(23), VRS_UTCTIME, 121),1,16) AS DATE
FROM STS_VEHICLE_RUNNING_STATUS
)AS T1
where rowno = 1
ORDER BY DATE ASC