Union
.英译:联盟,联合
联合结果集,集合运算符
select '最高成绩' as 内容,max(tsenglish) as 分数from tblscore
union
select '最低成绩',min(tsenglish) from tblscore
union
select '平均成绩' avg(tsenglish) from tblscore
结果如图:
常见应用:底部汇总 <
.英译:联盟,联合
联合结果集,集合运算符
select '最高成绩' as 内容,max(tsenglish) as 分数from tblscore
union
select '最低成绩',min(tsenglish) from tblscore
union
select '平均成绩' avg(tsenglish) from tblscore
结果如图:
常见应用:底部汇总 <