您可以使用这样的“行生成器”技术 （针对Hogan的评论进行编辑） ：
Select RG.Day, count(orders)From Orders_Table, (SELECt trunc(SYSDATE) - ROWNUM as Day FROM (SELECt 1 dummy FROM dual) ConNECT BY LEVEL <= 365 ) RGWhere RG.Day <=To_Date('##/##/####','MM/DD/YYYY') and RG.Day >=To_Date('##/##/####','MM/DD/YYYY') and Order_Open_Date(+) <= RG.Day and Order_Close_Date(+) >= RG.Day - 1Group by RG.DayOrder by RG.Day这应该列出上一年的每一天以及相应的订单数量
