|
本帖最后由 雪舞子 于 2014-1-11 13:37 编辑
C03051:雪舞子- select * from [成绩$]
- select *,(语文+数学+英语)/3 as 平局分 from [成绩$] where 班级 = "三班"
- select 姓名,语文+数学+英语 as 总分 from [成绩$] where 班级 = "七班"
- select 姓名,班级,语文+数学+英语 as 总分 from [成绩$] order by 语文+数学+英语 desc
- 选做
- select 姓名,"语文" as 组别,语文 as 得分 from [成绩$] union all select 姓名,"数学" as 组别,数学 from [成绩$] union all select 姓名,"英语" as 组别,英语 from [成绩$] order by 姓名 desc
复制代码 |
评分
-
查看全部评分
|