云数据库 GAUSSDB-DELETE:语法格式

时间:2024-11-01 17:13:45

语法格式

1
2
3
4
5
6
7
[ WITH [ RECURSIVE ] with_query [, ...] ]
DELETE [/*+ plan_hint */] [FROM] [ ONLY ] {table_name [ * ] subquery [ [ AS ] alias ] | view_name [ [ AS ] alias ]}
    [ USING using_list ]
    [ WHERE condition | WHERE CURRENT OF cursor_name ] 
    [ ORDER BY {expression [  ASC | DESC | USING operator ] } ]
    [ LIMIT row_count ]
    [ RETURNING { * | { output_expr [ [ AS ] output_name ] } [, ...] } ];
support.huaweicloud.com/distributed-devg-v8-gaussdb/gaussdb-12-0584.html