17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT DISTINCT sbbh, cdbh
FROM GCJL
WHERE GCSJ >= TO_DATE ('2014-01-15 08:00:00', 'YYYY-MM-DD HH24:MI:SS')
AND GCSJ <= TO_DATE ('2014-01-15 09:00:00', 'YYYY-MM-DD HH24:MI:SS');
SELECT CDXX.SBBH,cdxx.CDBH,max(imgurl)
FROM CDXX cdxx left join GXJL gcjl
on CDXX.SBBH=gcjl.sbbh AND cdxx.CDBH = gcjl.cdbh
WHERE jgsj >= TO_DATE ('2014-01-15 08:00:00', 'YYYY-MM-DD HH24:MI:SS')
AND jgsj <= TO_DATE ('2014-01-15 08:00:01', 'YYYY-MM-DD HH24:MI:SS')
group by CDXX.SBBH,cdxx.CDBH;
SELECT distinct CDXX.SBBH,cdxx.CDBH
FROM CDXX cdxx left join GXJL gcjl
on CDXX.SBBH=gcjl.sbbh AND cdxx.CDBH = gcjl.cdbh
WHERE jgsj >= TO_DATE ('2014-01-15 08:00:00', 'YYYY-MM-DD HH24:MI:SS')
AND jgsj <= TO_DATE ('2014-01-15 08:00:01', 'YYYY-MM-DD HH24:MI:SS')
这样又无法得到我想要的 图片路径 求解 求解