oracle报错:missing right parenthesis;
报错SQL
select rownum,rowid from(
select rowid rid,a.amt from user a order by amt desc;
)
where rownum<10;
这里报错右括号缺失,是因为子查询里多了个分号…
oracle报错:missing right parenthesis;
报错SQL
select rownum,rowid from(
select rowid rid,a.amt from user a order by amt desc;
)
where rownum<10;
这里报错右括号缺失,是因为子查询里多了个分号…