SQL - Count by range

Question

How can I select the number of population by age group

count ( 0->10)
count ( 11->20)

possible duplicate of [In SQL, how can you "group by" in ranges?](http://stackoverflow.com/questions/232387/in-sql-how-can-you-group-by-in-ranges) — RichardTheKiwi, Jan 25 '11 at 10:14
I found this http://stackoverflow.com/questions/3247630/mysql-group-by-age-range-including-null-ranges might also be a solution to count the group-by age-range — , Aug 04 '11 at 19:13

score 5 · Accepted Answer · edited May 23 '17 at 12:30

5

There are other question about the same, you can found the solution on: In SQL, how can you "group by" in ranges?

The syntax is valid for mysql too.

edited May 23 '17 at 12:30

Community

answered Jan 25 '11 at 09:40

Borja

score 4 · Answer 2 · answered Jan 25 '11 at 09:41

4

Try this:

SELECT FLOOR(age / 10), COUNT(*)
FROM yourTable
GROUP BY FLOOR(age / 10)

Manipulate the age / 10 expression to get the exact ranges. This will return 0 for ages 0-9, 1 for ages 10-19, etc.

answered Jan 25 '11 at 09:41

eumiro

1

Thanks for your replay, but if have a range as : 0-7, 8-15, 16-30, – Chaabelasri E. Jan 25 '11 at 10:41

2 Answers2