当我运行以下查询时:
select trunc(create_date), count(*) as num_created
from mytable WHERE create_date >= (sysdate -9)
group by trunc(create_date) order by 1;
输出:
06-MAR-24 7
07-MAR-24 1826
08-MAR-24 1135
09-MAR-24 1253
10-MAR-24 1119
11-MAR-24 1446
12-MAR-24 1400
13-MAR-24 2498
14-MAR-24 1633
15-MAR-24 616
当我运行下面的查询:
select trunc(create_date), count(*) as num_created
from mytable WHERE create_date >= (sysdate -10)
group by trunc(create_date) order by 1;
输出:
05-MAR-24 165
06-MAR-24 1020
07-MAR-24 1826
08-MAR-24 1135
09-MAR-24 1253
10-MAR-24 1119
11-MAR-24 1446
12-MAR-24 1400
13-MAR-24 2498
14-MAR-24 1633
15-MAR-24 616
想知道为什么3月6日的数字从7变成了1020.(依此类推)我在这里错过了什么,或者做错了什么?