请教ORACLE这句SQL哪里错了

显示全部楼层 · 2009-4-29 12:05:35

select COUNT(*),XF_TXDATE
from XF_DAREPLENISH
GROUP BY XF_TXDATE
ORDER BY XF_TXDATE
WHERE XF_TXDATE>'2005-01-01 00:00:00'
不加where是可以运行的，XF_TXDATE是诸如2005-01-01 00:00:00的DATE型数据

千问 · 2009-4-29 12:05:35

顺序错了，where条件应该在分组之前：select COUNT(*),XF_TXDATE from XF_DAREPLENISH WHERE XF_TXDATE>'2005-01-01 00:00:00' GROUP BY XF_TXDATE ORDER BY XF_TXDATE...

千问 · 2009-4-29 12:05:35

select COUNT(*),XF_TXDATE from XF_DAREPLENISH WHERE to_char(XF_TXDATE,'yyyy-mm-dd hh24:mi:ss')>'2005-01-01 00:00:00' GROUP BY XF_TXDATE ORDER BY XF_TXDATE...

千问 · 2009-4-29 12:05:35

试试whereXF_TXDATE-'2005-01-01 00:00:00'>0不行的话应该需要一个转换函数，把日期型转换为数值型，这样才可以直接比较。...

千问 · 2009-4-29 12:05:35

Select COUNT(*),XF_TXDATE from XF_DAREPLENISH WHERE TO_CHAR(XF_TXDATE,'YYYYMMDD')>'20050101' GROUP BY XF_TXDATE ORDER BY XF_TXDATE...

千问 · 2009-4-29 12:05:35

select COUNT(*),XF_TXDATE from XF_DAREPLENISH WHERE XF_TXDATE>'2005-01-01 00:00:00' GROUP BY XF_TXDATE ORDER BY XF_TXDATE...