Oracle with as用法

欢迎使用Markdown编辑器

with
t1 as 
(select 'A' as kmdm,count(*) as a from cjb where kmcj>=80),
t2 as 
(select 'A'  kmdm,count(*) as a from cjb where kmcj>=60),
t3 as 
(select 'A'  kmdm,count(*) as a from cjb where kmcj<60 and qkbz='0'),
t4 as 
(select 'A'  kmdm,count(*) as a from cjb where qkbz='0')
select t1.a,round((t1.a/t4.a),4)*100 "优秀率",t2.a,round((t2.a/t4.a),4)*100 "及格率",t3.a,round((t3.a/t4.a),4)*100 "良好" from t1,t2,t3,t4 where t1.kmdm=t2.kmdm and t2.kmdm=t3.kmdm and t3.kmdm=t4.kmdm

每一个as语句后边加","(最后一个除外)