您可以使用这样的“行生成器”技术 (针对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
这应该列出上一年的每一天以及相应的订单数量
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)