凤江湖论坛 › 呼和浩特性息 › 呼市小姐姐

sr4603049 发表于 2020-12-3 08:51:46

帮帮顶顶！！

bujin 发表于 2020-12-9 18:44:02

没看完~~~~~~ 先顶，好同志

旧梦已是曾经 发表于 2020-12-19 15:54:08

支持一下:lol

saber1 发表于 2020-12-22 08:53:34

小手一抖，江湖币到手！

齐天大圣X 发表于 2020-12-24 13:07:52

不知该说些什么。。。。。。就是谢谢

cdasdf1234 发表于 2020-12-26 01:54:04

可以哦，兄弟，有福利呀

cdasdf1234 发表于 2020-12-26 01:54:08

可以哦，兄弟，有福利呀

lhx16 发表于 2021-2-9 22:34:53

路过，学习下

gghhoos 发表于 2021-2-9 22:45:55

看看我是否认识呢

duzhi 发表于 2021-3-9 11:43:04

select * from (
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000,1) y ,'招生人数' as s ,area
from admissions_data_info
group by business_year,area
union all
select business_year x,round(cast(sum(school_age_number)as decimal(20,2))/1000,1) y ,'入学缺口' as s ,area
from admissions_data_info
group by business_year,area
union all
select business_year x,round(cast(sum(recruit_student_count) as decimal(20,2))/1000 ,1) y ,'招生人数' as s ,'所有区县' area
from admissions_data_info
group by business_year
union all
select business_year x,round(cast(sum(school_age_number) as decimal(20,2))/1000,1) y ,'入学缺口' as s ,'所有区县' area
from admissions_data_info
group by business_year
)a
where area=:area
order by x

查看完整版本: 呼市小姐姐