我想统计一下,2004-1-1 到 2004-2-3 每天的人数,sql语句怎么写??

Question

SELECT TRUNC(DATE),SUM(NUM) FROM AA 
WHERE DATE BETWEEN TO_DATE('20040101','YYYYMMDD')
AND TO_DATE('20040203','YYYYMMDD') 
GROUP BY TRUNC(DATE);

Answer 1

如果默认15天为一旬
 
SELECT  TRUNC((TRUNC(DATE)-TRUNC(DATE,'MM'))/15),SUM(NUM)  FROM  AA    
WHERE  DATE  BETWEEN  TO_DATE('20040101','YYYYMMDD')  
AND  TO_DATE('20040203','YYYYMMDD')    
GROUP  BY  TRUNC((TRUNC(DATE)-TRUNC(DATE,'MM'))/15);

Answer 2

呵呵...bzszp(www.bzszp.533.net)想着怎么实现功能,把时间忘记了.其实你只要设置时间条件(开始日期和结束日期就可以查任何时间段)就可以了.

Answer 3

dinya2003(OK)人呢,你写出来,让我看看!!!

Answer 4

SELECT  TO_CHAR(DATE,'YYYYMM')||TRUNC((TRUNC(DATE)-TRUNC(DATE,'MM'))/10),SUM(NUM)  FROM  AA          
WHERE  DATE  BETWEEN  TO_DATE('20040101','YYYYMMDD')      
AND  TO_DATE('20040203','YYYYMMDD')          
GROUP BY TO_CHAR(DATE,'YYYYMM')||TRUNC((TRUNC(DATE)-TRUNC(DATE,'MM'))/10);

Answer 5

SELECT TO_CHAR(DATE,'MM')||DECODE(TRUNC((TRUNC(DATE)-TRUNC(DATE,'MM'))/10),0,'上旬',1,'中旬]','下旬'),
SUM(NUM)    
FROM    AA                      
WHERE    DATE    BETWEEN    TO_DATE('20040101','YYYYMMDD')              
AND    TO_DATE('20040203','YYYYMMDD')                      
GROUP BY TO_CHAR(DATE,'MM')||DECODE(TRUNC((TRUNC(DATE)-TRUNC(DATE,'MM'))/10),0,'上旬',1,'中旬]','下旬');