【文件属性】:
文件名称:数据查询-排序-DB2 SQLSERVER 的SQL规范化
文件大小:6.53MB
文件格式:PPT
更新时间:2021-04-25 19:37:22
DB2 SQLSERVER 规范
数据查询-排序
升序排列
降序排列
SELECT StudentID As 学员编号,(Score*0.9+5) As 综合成绩
FROM Score
WHERE (Score*0.9+5)>60
ORDER BY Score
SELECT Au_Lname +'.' +Au_fName AS EMP
From Authors Union
SELECT fName +'.'+ LName AS EMP
From Employee
ORDER BY EMP DESC