00907专题

【Oracle】ORA-00907:missing right parenthesis右括号缺失

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