提示未找到预期FROM关键字

[chinaseven]

下面语句将两个TO_DATE()改为'20040812',在SQL2000下运行没有问题

数据库改为oracle后，提示未找到预期FROM关键字


SELECT *,(SELECT SUM(B.amount)
FROM (SELECT CONVERT(varchar(10), chargetime, 120) AS dt, SUM(amount)
AS amount
FROM cquancun
GROUP BY CONVERT(varchar(10), chargetime, 120)) B
WHERE datediff(dd, B.dt, A.rq) >= 0) AS total
FROM (SELECT CONVERT(varchar(10), chargetime, 120) AS rq, SUM(C.amount)
AS chargeamount
FROM cquancun C
where chargetime>TO_DATE('20040212','YYYYMMDDHH24MISS') and
chargetime<TO_DATE('20040812','YYYYMMDDHH24MISS')
GROUP BY CONVERT(varchar(10), chargetime, 120)) A
order by A.rq;

[hzwm]

select a.*, 字段
这样的做法容易出问题，最好是写成字段列表的形式，查询的速度也会很快。

[chinaseven]

问题解决，谢谢各位，结账

SELECT A.rq,A.chargeamount,(SELECT SUM(B.amount)
FROM (SELECT to_char(chargetime,'yyyymmdd') AS dt, SUM(amount)
AS amount
FROM cquancun
GROUP BY to_char(chargetime,'yyyymmdd')) B
WHERE to_number(A.rq)-to_number(B.dt) >= 0) AS total
FROM (SELECT to_char(chargetime,'yyyymmdd') AS rq, SUM(C.amount)
AS chargeamount
FROM cquancun C
where chargetime>TO_DATE('20040212','YYYYMMDDHH24MISS') and chargetime<TO_DATE('20040812','YYYYMMDDHH24MISS')
GROUP BY to_char(chargetime,'yyyymmdd')) A
order by A.rq;

[txlicenhe]

SELECT a.*,(SELECT SUM(B.amount)
............




SELECT a.*,(SELECT SUM(B.amount)
FROM (SELECT CONVERT(varchar(10), chargetime, 120) AS dt, SUM(amount)
AS amount
FROM cquancun
GROUP BY CONVERT(varchar(10), chargetime, 120)) B
WHERE datediff(dd, B.dt, A.rq) >= 0) AS total
FROM (SELECT CONVERT(varchar(10), chargetime, 120) AS rq, SUM(C.amount)
AS chargeamount
FROM cquancun C
where chargetime>TO_DATE('20040212','YYYYMMDDHH24MISS') and
chargetime<TO_DATE('20040812','YYYYMMDDHH24MISS')
GROUP BY CONVERT(varchar(10), chargetime, 120)) A
order by A.rq;

[chinaseven]

高手：

提示 缺少表达式

[drabit]

从没听说过oracle有convert函数

[ern]

没有convert的，那是sybase的吧
其次，对于*，最好放在最后，不然是会出些莫名其妙的错误，或者你手动把字段都列出来

[chinaseven]

oracle 里 datediff函数有没有？

[drabit]

没有

[ern]

oracle里直接比较日期就可以了