一条SQL取出今天、昨天、本月的数据不知可否? 大概为:pdate pcount2009-06-05 112009-06-05 212009-06-06 122009-06-06 322009-06-07 562009-06-07 26我想一条SQL取出今天、昨天、本月的数据不知可有办法?如今天浏览 82 昨天44 本月189 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你提供的例子并不准确,今天已经是 2009-06-13 了mysql> select * from tx;+------------+--------+| pdate | pcount |+------------+--------+| 2009-06-05 | 11 || 2009-06-05 | 21 || 2009-06-06 | 12 || 2009-06-06 | 32 || 2009-06-07 | 56 || 2009-06-07 | 26 |+------------+--------+6 rows in set (0.00 sec)mysql> select '今天',sum(pcount) from tx where pdate=CURDATE() -> union all -> select '昨天',sum(pcount) from tx where pdate=DATE_SUB(CURDATE(),INTERVAL 1 DAY) -> union all -> select '本月',sum(pcount) from tx where pdate>DATE_SUB(CURDATE(),INTERVAL DAYOFMONTH(CURDATE())-1 DAY) ;+------+-------------+| 今天 | sum(pcount) |+------+-------------+| 今天 | NULL || 昨天 | NULL || 本月 | 158 |+------+-------------+3 rows in set (0.00 sec)mysql> 或者如下mysql> select sum(if(pdate=CURDATE(),pcount,0)) as '今天', -> sum(if(pdate=DATE_SUB(CURDATE(),INTERVAL 1 DAY),pcount,0)) as '昨天', -> sum(pcount) as '本月' -> from tx -> where pdate>DATE_SUB(CURDATE(),INTERVAL DAYOFMONTH(CURDATE())-1 DAY) ;+------+------+------+| 今天 | 昨天 | 本月 |+------+------+------+| 0 | 0 | 158 |+------+------+------+1 row in set (0.00 sec)mysql> asp mysql 5.19 odbc 关于asp连接数据库问题。 如何建立数据库表空间 关于MYSQL数据库脚本导入信息异常问题 mysql 查询时间的问题 mysql问题!昨天有人责怪我对高手大呼小叫的!今天就低调一点! SQL数据库分配错误如何修复 高手请指点 急救!我的表到哪儿去了! 关于enum类型问题 怎样实现对字段使用函数查询 急急急!用工具将Oracle转换为mysql后中文乱码无法消除? 如何让mysql结束一个对五千万条记录的查询
+------------+--------+
| pdate | pcount |
+------------+--------+
| 2009-06-05 | 11 |
| 2009-06-05 | 21 |
| 2009-06-06 | 12 |
| 2009-06-06 | 32 |
| 2009-06-07 | 56 |
| 2009-06-07 | 26 |
+------------+--------+
6 rows in set (0.00 sec)mysql> select '今天',sum(pcount) from tx where pdate=CURDATE()
-> union all
-> select '昨天',sum(pcount) from tx where pdate=DATE_SUB(CURDATE(),INTERVAL 1 DAY)
-> union all
-> select '本月',sum(pcount) from tx where pdate>DATE_SUB(CURDATE(),INTERVAL DAYOFMONTH(CURDATE())-1 DAY) ;
+------+-------------+
| 今天 | sum(pcount) |
+------+-------------+
| 今天 | NULL |
| 昨天 | NULL |
| 本月 | 158 |
+------+-------------+
3 rows in set (0.00 sec)mysql>
-> sum(if(pdate=DATE_SUB(CURDATE(),INTERVAL 1 DAY),pcount,0)) as '昨天',
-> sum(pcount) as '本月'
-> from tx
-> where pdate>DATE_SUB(CURDATE(),INTERVAL DAYOFMONTH(CURDATE())-1 DAY) ;
+------+------+------+
| 今天 | 昨天 | 本月 |
+------+------+------+
| 0 | 0 | 158 |
+------+------+------+
1 row in set (0.00 sec)mysql>