- INSERT INTO SE_STAT_ORG (
- RECORD_DATE,
- ORG_ID,
- ORG_NAME,
- SIGN_CONT_COUNT,
- SIGN_ARRI_CONT_COUNT,
- SIGN_CONT_MONEY,
- SIGN_ARRI_CONT_MONEY,
- TOTAL_ARRI_CONT_COUNT,
- TOTAL_ARRI_MONEY,
- PUBLISH_TOTAL_COUNT,
- PROJECT_COUNT
- ) SELECT
- *
- FROM
- (
- SELECT
- '2012-06-09' RECORD_DATE,
- PARENT_ORG_ID,
- PARENT_ORG_NAME,
- SUM(SIGN_CONT_COUNT) SIGN_CONT_COUNT,
- SUM(SIGN_ARRI_CONT_COUNT) SIGN_ARRI_CONT_COUNT,
- SUM(SIGN_CONT_MONEY) SIGN_CONT_MONEY,
- SUM(SIGN_ARRI_CONT_MONEY) SIGN_ARRI_CONT_MONEY,
- SUM(TOTAL_ARRI_CONT_COUNT) TOTAL_ARRI_CONT_COUNT,
- SUM(TOTAL_ARRI_MONEY) TOTAL_ARRI_MONEY,
- SUM(PUBLISH_TOTAL_COUNT) PUBLISH_TOTAL_COUNT,
- SUM(PROJECT_COUNT) PROJECT_COUNT,
- FROM SE_STAT_USER
- WHERE DATE_FORMAT(RECORD_DATE, '%Y-%m-%d') = '2012-06-09'
- GROUP BY PARENT_ORG_ID
- ) M
来源: http://www.qdfuns.com/article/31721/1de252bfd230338661b392c378216b36.html