Mysql fetch data with count and between date

Question

This is my table structure. I have to fetch the zip_code's range as per they created in database table in given between date.

enter image description here

For example in the given between dates are 4-aug-14 to 9-aug-14 i need follwing result

zip number

90620 10

90621 5

How i write mysql query for this.

Nisar · Accepted Answer · 2014-08-07 04:55:37Z

2

IS this you want the result DEMO

try

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

answered Aug 7, 2014 at 4:55

Nisar

6,09818 gold badges71 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Trav L · Accepted Answer · 2014-08-07 04:13:00Z

1

Try this:

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

answered Aug 7, 2014 at 4:13

Trav L

15.3k6 gold badges34 silver badges39 bronze badges

Comments

Jeyachandran Rathnam · Accepted Answer · 2014-08-07 04:14:57Z

1

try :

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

edited Aug 7, 2014 at 4:14

answered Aug 7, 2014 at 4:08

Jeyachandran Rathnam

3142 silver badges12 bronze badges

Collectives™ on Stack Overflow

Mysql fetch data with count and between date

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related