java.sql.sqlexception:COMPILE FAILED:parss error:[error 1102] line1:7 missing AS at '(' near '(' in statement line 1:8 cannot recognize input near 'org_code,tnx_rate' in statement
hive数据库
with b as ( select 查询语句)
select *
from(
select 查询语句,row_number()over() as rowno
from b
)tt
where rowno<=
这样写 row_num()over() 字段 再外面嵌套一层再筛选使用
你的sql贴出来看看你，sql有问题
with 表名 as （select 语句）
好像没有你截图中那样表名后面还带字段名的。
其次，MySQL使用with查询因子，好像要版本8.0之后
1min目标场景问卷
立即参与
java.sql.sqlexception:COMPILE FAILED:parss error:[error 1102] line1:7 missing AS at '(' near '(' in statement line 1:8 cannot recognize input near 'org_code,tnx_rate' in statement
