[WHERE clause]?
[GROUP BY clause]?
[HAVING clause]?
[ORDER BY clause]?
[COMPUTE clause]?
其中:?
select_list指定列
(ALL则为所有列,DISTINCT为不选相同记录?
new_table_name指定目标表名?
table_name|view_name指定源表名或源视图名?
WHERE clause给出选择条件?
GROUP BY clause按clause分组处理?
HAVING clause给出分组处理的条件?
ORDER BY clause按clause排序?
COMPUTE clause则产生新行