呼市小姐姐

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

zkyoeu · 发表于 2021-3-22 07:37:02

小手一抖，江湖币到手！

scottymax · 发表于 2021-4-9 00:41:58

路过，支持一下啦

nishengri123 · 发表于 2021-5-12 20:40:46

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

byf811 · 发表于 2021-5-22 06:33:12

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

vampirely · 发表于 2021-6-9 16:48:08

学习了，不错，讲的太有道理了

z零11 · 发表于 2021-6-10 10:00:34

小手一抖，江湖币到手！

kkk030301 · 发表于 2021-6-15 14:34:47

路过，支持一下啦

去去去去 · 发表于 2021-6-16 08:42:35

相当不错，感谢无私分享精神！

lioyed · 发表于 2021-6-21 09:47:10

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

		自动登录	找回密码
密码			立即注册

[呼和浩特] 呼市小姐姐