select B.OPERATORID,U.USR_Name,sum(FileScanNumber)
from
Key_Batch B, Key_Users U
where B.OperatorID=U.USR_ID
and (SUBMIT_DATE Between to_date('2009-08-07 00:00:00','yyyy-MM-dd HH24:MI:SS') and to_date('2009-08-07 23:59:59','yyyy-MM-dd HH24:MI:SS'))
group by OPERATORID, USR_Name,USR_ID 看一下字符转成时间,应该是这里的问题,不太懂ORACLE
from
Key_Batch B, Key_Users U
where B.OperatorID=U.USR_ID
and (SUBMIT_DATE Between to_date('2009-08-07 00:00:00','yyyy-MM-dd HH24:MI:SS') and to_date('2009-08-07 23:59:59','yyyy-MM-dd HH24:MI:SS'))
group by OPERATORID, USR_Name,USR_ID 看一下字符转成时间,应该是这里的问题,不太懂ORACLE
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货