sample188.sql

来自「T-SQL示例大全」· SQL 代码 · 共 11 行

/* 文件名称: Sample188.sql */
USE 北风贸易

SELECT 姓名 = name,班级 = class,年级 = grade,中文 = chinese,英文 = english FROM stud87
  UNION ALL
SELECT * FROM stud88
  UNION ALL
SELECT * FROM stud89
  ORDER BY 年级,班级,姓名 DESC