作者eliang ()
看板Database
标题[SQL ] 请教SQL达人 (有关GROUP BY)
时间Sat Aug 2 18:00:06 2008
假设我有一个用来储存访客记录的资料表:
+----+------+------------+
| id | name | visit_date |
+----+------+------------+
| 1 | Tom | 2007-12-01 |
| 2 | Mary | 2007-12-01 |
| 3 | John | 2007-12-10 |
| 4 | Sean | 2007-12-10 |
| 5 | Tim | 2007-12-10 |
| 6 | Ben | 2007-12-20 |
| 7 | Tom | 2008-01-02 |
| 8 | Jack | 2008-01-02 |
+----+------+------------+
若我要统计「每日访客量」, 我可以用以下 SQL:
SELECT visit_date, COUNT(*) AS visits FROM table GROUP BY visit_date
即可产生如下结果:
+------------+--------+
| visit_date | visits |
+------------+--------+
| 2007-12-01 | 2 |
| 2007-12-10 | 3 |
| 2007-12-20 | 1 |
| 2008-01-02 | 2 |
+------------+--------|
我想请问那「每周」,「每月」, 或「每年」访客量的 SQL 又该如下呢?
先谢谢了!
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 220.132.133.199