sql 查询数据小计 合计

 SELECT   SUM (AMOUNT), ndate, customer_name
    FROM   (SELECT   *
              FROM   V_JK_DEBT_CUSTOMER_SUB
             WHERE       customer_vip = 1
                     AND status = '正常'
                     AND ndate>= TO_DATE ('2011-11-01', 'yyyy-MM-dd') AND ndate<= TO_DATE ('2011-12-26', 'yyyy-MM-dd')
                     AND unit = 'CDW'
                     AND (ntype = 1 OR ntype = 8)
                     AND amount < 0) NFACT
GROUP BY   ROLLUP (customer_name, ndate)
ORDER BY   customer_name, ndate