云数据库 GaussDB-SELECT INTO:语法格式

时间：2023-11-01 16:22:03

云数据库 GaussDB

语法格式

[ WITH [ RECURSIVE ] with_query [, ...] ]SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]    { * | {expression [ [ AS ] output_name ]} [, ...] }    INTO [ [ GLOBAL | LOCAL ] [ TEMPORARY | TEMP ] | UNLOGGED ] [ TABLE ] new_table    [ FROM from_item [, ...] ]    [ WHERE condition ]    [ GROUP BY expression [, ...] ]    [ HAVING condition [, ...] ]    [ WINDOW {window_name AS ( window_definition )} [, ...] ]    [ { UNION | INTERSECT | EXCEPT | MINUS } [ ALL | DISTINCT ] select ]    [ ORDER BY {expression [ [ ASC | DESC | USING operator ] | nlssort_expression_clause ] [ NULLS { FIRST | LAST } ]} [, ...] ]    [ LIMIT { count | ALL } ]    [ OFFSET start [ ROW | ROWS ] ]    [ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]    [ {FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT |WAIT N]} [...] ];

上一篇：云数据库 GaussDB-SAVEPOINT:示例

下一篇：云数据库 GaussDB-SAVEPOINT:示例