视图数据sql用order by排序报错

【myApps/OBPM版本号】：v4.4- sp XX
【浏览器类型】：Chrome/其他
【联系方式-QQ】：请留下您的QQ号码
【联系电话】:    请留下您的联系电话，以便技术同事更好解决您的问题
【问题描述】：
sql

1. var sql = "SELECT * FROM ( SELECT *, ( SELECT MAX(item_记录日期) FROM tlk_工时填报 WHERE item_项目编号 = a.ITEM_项目编号 AND item_填写人 = '__njohgoBe65nIG7IBSX8' ) serviceTime FROM tlk_售前项目 a WHERE item_售前负责人 LIKE '%__njohgoBe65nIG7IBSX8%' AND item_项目状态 = '正常' ) AS tlk_ceshi2 ORDER BY serviceTime DESC LIMIT 5"

复制代码

报错

1. {"errcode":500,"errmsg":"SELECT * FROM ( SELECT * FROM (SELECT * FROM (SELECT * FROM ( SELECT *, ( SELECT MAX(item_记录日期) FROM tlk_工时填报 WHERE item_项目编号 = a.ITEM_项目编号 AND item_填写人 = '__njohgoBe65nIG7IBSX8' ) serviceTime FROM tlk_售前项目 a WHERE item_售前负责人 LIKE '%__njohgoBe65nIG7IBSX8%' AND item_项目状态 = '正常' ) AS tlk_ceshi2 ORDER BY serviceTime DESC LIMIT 5) table_orderby) table_0 WHERE table_0.DOMAINID = ?  ) AS TB  ORDER BY SERVICETIME DESC LIMIT 5 LIMIT 0,10"}

复制代码

您好。
两个limit了，sql里面不要写limit

已解决可结帖