sql - 错误报告 - SQL 错误：ORA-00933：SQL 命令未正确结束

Question

我怎样才能克服它？

select * 
from clothorder 
ORDER BY orderId DESC 
LIMIT 1 
where custId='[e-mail]';

标签： sql

Answer 1

where 子句位于 ORDER BY 子句之前：

SELECT * 
FROM clothorder 
WHERE custId='[e-mail]' 
ORDER BY orderId DESC 
LIMIT 1;