这条SQL语句能优化吗?
select * from (select VehicleLic 车牌号,Longitude 经度,Latitude 纬度,Position 地址,min(GpsDateTime) 开始时间,max(GpsDateTime)结束时间,count(*) 记录数,convert(char(8),(max(GpsDateTime)-min(GpsDateTime)),108) 时间 from gps00320110206 a,VehicleInfo b where a.VehicleID=b.VehicleID group by VehicleLic,Longitude,Latitude,Position having count(*)>1) as c
where 时间<='00:10:00' and 开始时间>'2011-02-06 12:25:38'and 结束时间<'2011-02-06 14:25:38'