hi,
sql statement,
SELECT CONVERT(VARCHAR(10), VRS_UTCTIME, 121) AS [Date],
MIN(SUBSTRING(CONVERT(VARCHAR(23), VRS_UTCTIME, 121), 12,20)) AS [start_time],
MAX(SUBSTRING(CONVERT(VARCHAR(23), VRS_UTCTIME, 121), 12,20)) AS [stop_time],
MAX(VRS_SPEED) AS [max_speed]
FROM STS_VEHICLE_RUNNING_STATUS
WHERE VRS_DEVICEID = 'ST0001' AND VRS_UTCTIME BETWEEN '2012-07-02' AND '2012-11-09'
GROUP BY CONVERT(VARCHAR(10), VRS_UTCTIME, 121)
retrieve data from table as,
Date start_time stop_time max_speed
---- ---------- --------- ---------
2012-07-02 10:59:26.000 11:33:36.000 40
2012-09-06 18:45:29.000 19:46:28.000 0.36
2012-10-09 12:10:12.000 01:12:12.000 50
but i want to retrieve the location point at this max_speed value.how can write
sql statement to retrieve the location point data with this result?
ie,
sql,
SELECT VRS_LATITUDE FROM STS_VEHICLE_RUNNING_STATUS
WHERE VRS_SPEED=(SELECT MAX(VRS_SPEED) FROM STS_VEHICLE_RUNNING_STATUS)
'How SQL retrieving max value plus corresponding another column value'?
-----------------------------------------------------------------------
plz help me...
Thanks
[edit]Code block added - OriginalGriff[/edit]