17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT AVG(SPEED)
INTO A,AVG(GPSSPEED) INTO B,COUNT(*) INTO C
FROM T_GPS_GPSDATA@ORACLE_CONNECT2
WHERE DEVICEID = D AND GPSTIME BETWEEN
TO_DATE(E, 'yyyy/MM/dd HH24:mi:ss') AND
TO_DATE(F, 'yyyy/MM/dd HH24:mi:ss');