Question

SQL语句错误select * from (SELECT bookid,count(bookid) as degree FROM

select * from (SELECT bookid,count(bookid) as degree FROM td_borrow group by bookid) as borr join (select b.*,c.name as bookcaseName,p.pubname,t.typename from td_bookinfo b left join td_bookcase c on b.bookcase=c.id join td_publishing p on b.ISBN=p.ISBN join td_booktype t on b.typeid=t.id where b.del=0) as book on borr.bookid=book.id order by borr.degree desc limit 10
执行后出现此错误： 消息 102，级别 15，状态 1，第 1 行 'limit' 附近有语法错误。

Answer 1

limit 10不能在 order 后面哦

追问

应该在哪里？

追答

select * from (

select * from (SELECT bookid,count(bookid) as degree FROM td_borrow group by bookid) as borr join (select b.*,c.name as bookcaseName,p.pubname,t.typename from td_bookinfo b left join td_bookcase c on b.bookcase=c.id join td_publishing p on b.ISBN=p.ISBN join td_booktype t on b.typeid=t.id where b.del=0) as book on borr.bookid=book.id order by borr.degree desc

) limit 10