mysql数据库查询语句有关limit问题，不能嵌套语句么？
SELECT*FROMstudentORDERBYgradeDESCLIMIT(selectcount(*)fromstudent)-2,2报错额#1064-Youhav...
SELECT *
FROM student
ORDER BY grade DESC
LIMIT (select count(*) from student)-2, 2
报错额#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '(select count(*) from student)-2, 2' at line 4 展开
FROM student
ORDER BY grade DESC
LIMIT (select count(*) from student)-2, 2
报错额#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '(select count(*) from student)-2, 2' at line 4 展开
展开全部
语法错误 您无法在limit里面嵌套语句
建议在程序中做两次查询将参数带入到 第二个语句中的 limit 中
建议在程序中做两次查询将参数带入到 第二个语句中的 limit 中
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
