• 闪存
• 博客
• 发言 小组
• 投递 新闻
• 提问 博问
• 添加 收藏
• 文库

这样的sql能优化吗，每次子查询只有条件不同

0

悬赏园豆：10 [已解决问题] 解决于 2015-05-16 16:59

1 select * from
2 (select count(*) as '计划任务' from hscdm_project_qc where task_date BETWEEN date_add(now(),interval -7 DAY ) and NOW() ) as t1,
3 (select count(*) as '报送数据' from hscdm_project_qc where task_status =2 and task_date BETWEEN date_add(now(),interval -7 DAY ) and NOW()  )as t2,
4 (select count(*) as '审核通过' from hscdm_project_qc where check_status=1 and task_date BETWEEN date_add(now(),interval -7 DAY ) and NOW()  ) as t3

服务器端和客户端都好 

sql server sql mysql

阿哈太阳 | 初学一级 | 园豆：23
提问于：2015-05-14 15:44

显示帮助

使用"Ctrl+Enter"可进行快捷提交，评论支持部分 Markdown 语法：[link](http://example.com) _italic_ **bold** `code`。

< >

分享

分享您的问题

SELECT
    COUNT(1) AS '计划任务',
    COUNT(CASE WHEN TASK_STATUS = 2 THEN 1 END) AS '报送数据',
    COUNT(CASE WHEN TASK_STATUS = 1 THEN 1 END) AS '审核通过'
FROM
    HSCDM_PROJECT_QC
WHERE
    TASK_DATE BETWEEN DATE_ADD(NOW(), INTERVAL - 7 DAY) AND NOW()