Question

oracle语句错误：SQL 命令未正确结束

ORA-00933: SQL 命令未正确结束SELECT count(id) FROM ( SELECT * FROM note WHERE 1=1 ORDER BY title asc ) AS a错在哪了？

Answer 1

SELECT count(id)
FROM (SELECT * FROM note WHERE 1=1 ORDER BY title asc) a

把最后那个as去掉看看？语法上看没有错误的，检查下是不是都是在英文状态输入的？

Answer 2

语句最后面加个分号呢？