数据仓库服务 GaussDB(DWS)-SELECT INTO:语法格式

时间:2023-11-01 16:15:26

语法格式

 1 2 3 4 5 6 7 8 91011121314
[ WITH [ RECURSIVE ] with_query [, ...] ]SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]    { * | {expression [ [ AS ] output_name ]} [, ...] }    INTO [ UN LOG GED ] [ 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 ] ] } | { LIMIT start, { count | ALL } } ]    [ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]    [ {FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT ]} [...] ];
support.huaweicloud.com/sqlreference-811-dws/dws_06_0239.html