Hi,
the SQL,
SELECT DATE,VRS_DEVICEID,LOCATION FROM
(
SELECT 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
GROUP BY DATE,
VRS_DEVICEID,LOCATION ORDER BY DATE ASC
retrieve data as below
DATE VRS_DEVICEID LOCATION
2012-07-02 10:59 ST001 TVM
2012-07-02 10:59 ST001 EKM
2012-07-02 10:59 ST001 ATTIGAL
2012-07-02 11:00 ST001 KOTTAKKAL
2012-07-02 11:00 ST001 KARAMANA
2012-07-02 11:02 ST001 MANNARKKAD
2012-07-02 11:02 ST001 PALAKKAD
But i want to retrieve it as below
DATE VRS_DEVICEID LOCATION
2012-07-02 10:59 ST001 TVM
2012-07-02 11:00 ST001 KOTTAKKAL
2012-07-02 11:02 ST001 MANNARKKAD
That is, the top row of each DATE.
Thanks..