§3.3查询语句 语句格式: SELECT[ ALL DISTINCT][表名.]{*列名表达 式[AS新列名] INTO:主变量1[,主变量2].] FROM表名[表别名], WER条件表达式|子查询] [ GROUP BY列名1, LHAVING分组表达式]] I UNION INTERSECT EXCEPT] SELECT.FROM. [ ORDER BY列名列序号[ ASC DESC],…];§3.3 查询语句 一、语句格式: SELECT [ALL|DISTINCT] [表名.]{*|列名|表达 式[AS 新列名]} [INTO :主变量1[,:主变量2]…] FROM 表名[表别名], … [WHERE 条件表达式|子查询] [GROUP BY 列名1, … [HAVING 分组表达式]] [{UNION|INTERSECT |EXCEPT}SELECT…FROM…] [ORDER BY 列名|列序号[ASC|DESC], …]；