select (select count(*) from Table1 Where Year>20)*100.0/(select count(*) from Table1) as 百分比
select count(select * from Table1 Where Year>20) as 百分比 from Table1
select * age>"20"....
set count1="?"(age>"20"....)
count3=count1/count
表结构是怎么样的？
要不然，别人怎么给你语句呢？
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024