日期:2014-05-17 浏览次数:20445 次
SELECT ( ROW_NUMBER() OVER ( ORDER BY r.send_date DESC ) ) rownumber ,
send_date ,
( SELECT COUNT(*)
FROM T_xmim_provide_log r1
WHERE r1.send_date = r.send_date
) AS person ,
( SELECT COUNT(*)
FROM T_xmim_Group_Provide_log r2
WHERE r2.send_date = r.send_date
) AS team
FROM T_xmim_provide_log r
GROUP BY send_date
UNION ALL
SELECT ( ROW_NUMBER() OVER ( ORDER BY r.send_date DESC ) ) rownumber ,
send_date ,
( SELECT COUNT(*)
FROM