how to write the sql?

See more:

SQL

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]