用计数和日期之间的Mysql获取数据

Question

这是我的桌子结构。我必须根据它们在给定日期之间的数据库表中创建的范围来获取zip_code的范围。

​

​

例如，在给定的日期之间是4-8月14日到9-8月14日，我需要后续的结果。

拉链号

90620 10

90621 5

我是如何编写mysql查询的。

Answer 1

这是您想要的结果DEMO吗？

试一试

SELECT zip
    , COUNT(1) AS count
FROM table1
WHERE created BETWEEN '2014-08-04 00:00:00' AND '2014-08-08 23:59:59'
GROUP BY zip
ORDER BY count DESC

Answer 2

试着：

Select zip, count(*) from table_name where created between 'from_date' and 'to_date' group by zip

Answer 3

试试这个：

SELECT zip
    , COUNT(id) AS count
FROM [table]
WHERE created BETWEEN '2014-08-04 00:00:00' AND '2014-08-08 23:59:59'
GROUP BY zip
ORDER BY count DESC