登录免费注册



select_stmt

首页  思维导图  详情



select_stmt

2018-08-30 14:37:40   2  举报





AI智能生成

hive select

hive

模版推荐

作者其他创作

大纲/内容

cte_select_stmt

WITH

cte_select_stmt_item *

ident

cte_select_cols?

（

ident *

）

AS

(

fullselect_stmt

）

fullselect_stmt

fullselect_stmt_item

subselect_stmt

SELECT | SEL

select_list

select_list_set?

ALL | DISTINCT

<strike>select_list limit?</strike>

TOP

expr

select_list_item *

<strike>into_clause?</strike>

INTO

ident ?

from_clause?

FROM

from_table_clause

from_table_name_clause

table_name

from_alias_clause?

table_name

AS?

ident

（

ID，*

）？

| from_subselect_clause

(

select_stmt

)

from_alias_clause?

||

from_table_valuse_clause

TABLE

（

VALUES<br>

from_table_values_row *

expr

||

(

expr *

)

）

from_alias_clause?

from_join_clause ?

，from_table_clause

||

from_join_type_clause

INNER? JOIN

||

(LEFT | RIGHT | FULL) OUTER? JOIN

+ from_table_clause ON bool_expr

where_clause?<br>

where

bool_expr

group_by_clause?

GROUP

BY

expr ASC | DESC ? *

having_clause | qualify_clause ?

HAVING bool_expr

QUALIFY bool_expr

order_by_clause?

ORDER

BY

expr ASC | DESC ? *

select_options?

select_options_item +

LIMIT expr | WITH (RR | RS | CS | UR) <b>(USE AND KEEP (EXCLUSIVE | UPDATE | SHARE) LOCKS)?</b>

( fullselect_stmt )

fullselect_set_clause

UNION ALL？

EXCEPT ALL ?

INTERSECT ALL ?

fullselect_stmt_item

Select,poll,epoll

 Collect

Get Started

Select,poll,epoll

 Collect

Get Started

PSB wireframe

 Collect

Get Started

PSB wireframe

 Collect

Get Started

select非阻塞













评论

0 条评论

下一页



图形选择

思维导图

主题

补充说明

AI生成





修改AI描述

去编辑

重新生成

提示 

关闭后当前内容将不会保存，是否继续？

取消

确定

Document