mysql统计一个月每天、每月、月汇总的统计.

表结构如下:
CREATE TABLE tempTB(
tId INT NOT NULL,
tMoney0 DECIMAL(18,2),
tMoney1 DECIMAL(18,2),
tranDate VARCHAR(20)
);
插入的数据:
INSERT INTO tempTB VALUES (1,100,0.00,'2013-2-12');
INSERT INTO tempTB VALUES (2,120,0.00,'2013-2-12');
INSERT INTO tempTB VALUES (3,0.00,1000.00,'2013-2-13');
INSERT INTO tempTB VALUES (4,100,0.00,'2013-2-13');
INSERT INTO tempTB VALUES (5,150,0.00,'2013-2-13');
INSERT INTO tempTB VALUES (6,0.00,200.00,'2013-2-13');
INSERT INTO tempTB VALUES (7,100,0.00,'2013-2-14');
INSERT INTO tempTB VALUES (8,0.00,200.00,'2013-2-14');
INSERT INTO tempTB VALUES (9,100,0.00,'2013-2-14');
INSERT INTO tempTB VALUES (10,100,0.00,'2013-3-14');
INSERT INTO tempTB VALUES (11,100,0.00,'2013-3-14');
INSERT INTO tempTB VALUES (12,100,0.00,'2013-4-14');
INSERT INTO tempTB VALUES (13,100,0.00,'2013-4-14');
现在要实现的排序效果如下:

tMoney0     tMoney1 tranDate #注释
120     0          2013-2-12
100     0          2013-2-12
220     0          2013-2-12 2月12日汇总
150     0          2013-2-13
0    1000          2013-2-13
0     200          2013-2-13
100     0          2013-2-13
250     1200  2013-2-13 2月13日汇总
100     0          2013-2-14
100     0          2013-2-14
0     200          2013-2-14 2月14日汇总
200     200          2013-2-14 3月13日汇总
670     1400  2013-2-14 2月汇总
100      0          2013-3-14
100     0          2013-3-14
200     0          2013-3-14 3月14日汇总
200     0          2013-3-14 3月汇总
100     0          2013-4-14
100     0          2013-4-14
200     0          2013-4-14 4月14日汇总
200     0          2013-4-14 4月汇总
1070     1400         总汇总

#方法一

SELECT *
    FROM(
       SELECT tMoney0,tMoney1,tranDate,NULL AS remark
       FROM tempTB
       UNION ALL
SELECT SUM(tMoney0),SUM(tMoney1),tranDate ,CONCAT(tranDate,'日汇总')
       FROM tempTB
       GROUP BY tranDate
       UNION ALL
SELECT SUM(tMoney0),SUM(tMoney1),MAX(tranDate) ,CONCAT(DATE_FORMAT(tranDate,'%Y-%c'),'月汇总')
       FROM tempTB
       GROUP BY DATE_FORMAT(tranDate,'%Y-%m')
       UNION ALL
      SELECT SUM(tMoney0),SUM(tMoney1),NULL ,'总汇总'
       FROM tempTB
      ) t
ORDER BY tranDate IS NULL,tranDate,remark ;
      
#方法二      
SELECT *  FROM (
SELECT tMoney0,tMoney1,tranDate,NULL AS remark FROM tempTB 
UNION ALL
SELECT SUM(tMoney0),SUM(tMoney1),tranDate,CONCAT(tranDate,'日汇总') FROM tempTB GROUP BY tranDate  WITH ROLLUP 
UNION ALL
SELECT SUM(tMoney0),SUM(tMoney1),MAX(tranDate),CONCAT(DATE_FORMAT(tranDate,'%Y-%c'),'月汇总')  FROM tempTB GROUP BY DATE_FORMAT(tranDate,'%Y-%m') 
) AS t 
ORDER BY tranDate IS NULL,tranDate,remark;