The INSERT with VALUES is a special case because it would not benefit from executing through SQE because the statement lacks selection criteria, grouping or ordering.
INSERT with VALUES是一个特例,因为它无法从通过SQE执行中受益,因为该语句没有选择标准、分组或排序。
2
Multiple slices of data can be returned in a single query by using grouping sets or super-groups (such as ROLLUP) in the GROUP-BY clause of the SQL statement.