SELECT STATION FROM (SELECT G.STATION FROM GPS_TIME G, CARD C WHERE C.ID = 1447647 AND G.TDATE >= DATE '2014-11-24' AND G.TDATE < DATE'2014-11-24' + 1 AND G.CAR_ID = '粤X13913' AND (C.TDATE < G.TDATE + 0.003 AND C.TDATE > G.TDATE - 0.003) ORDER BY ABS(C.TDATE - G.TDATE)) WHERE ROWNUM = 1;
FROM (SELECT G.STATION
FROM GPS_TIME G, CARD C
WHERE C.ID = 1447647
AND G.TDATE >= DATE '2014-11-24'
AND G.TDATE < DATE'2014-11-24' + 1
AND G.CAR_ID = '粤X13913'
AND (C.TDATE < G.TDATE + 0.003 AND C.TDATE > G.TDATE - 0.003)
ORDER BY ABS(C.TDATE - G.TDATE))
WHERE ROWNUM = 1;
sql中尽量不要对字段使用函数
还有你的两个表关联,应该需要两个表的car_id做连接条件吧