MYSQL自定义指定数字查询

sql

// An highlighted block
```select 
a.class_id ,
ifnull(b.score,0) as score
 from 
(
SELECT 0 class_id 
UNION ALL SELECT 1 class_id 
UNION ALL SELECT 2 class_id 
UNION ALL SELECT 3 class_id 
UNION ALL SELECT 4 class_id 
UNION ALL SELECT 5 class_id 
UNION ALL SELECT 6 class_id 
UNION ALL SELECT 7 class_id 
UNION ALL SELECT 8 class_id 
UNION ALL SELECT 9 class_id 
UNION ALL SELECT 10 class_id 
UNION ALL SELECT 11 class_id 
UNION ALL SELECT 12 class_id
UNION ALL SELECT 13 class_id 
UNION ALL SELECT 14 class_id 
UNION ALL SELECT 15 class_id 
UNION ALL SELECT 16 class_id 
UNION ALL SELECT 17 class_id 
UNION ALL SELECT 18 class_id 
UNION ALL SELECT 19 class_id 
UNION ALL SELECT 20 class_id 
UNION ALL SELECT 21 class_id 
UNION ALL SELECT 22 class_id 
UNION ALL SELECT 23 class_id
) a
left join 
(
SELECT age , count(height)  score FROM user_ext group by age 
) b
on a.class_id = b.age 
order by a.class_id


## 例子
age	height	
11	135	
9	    145	
10	134	
11	142	
12	139	
11	140
##输出
class_id	score
0			0
1			0
2			0
3			0
4			0
5			0
6			0
7			0
8			0
9			1
10			1
11			3
12			1
13			0
14			0
15			0
16			0
17			0
18			0
19			0
20			0
21			0
22			0
23			0