select_stmt
2018-08-30 14:37:40 2 举报AI智能生成
hive select
作者其他创作
大纲/内容
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
收藏
0 条评论
下一页
