Question

把sql sever语句改为mysql，小弟初学，希望能得到答复，关键是语法的改写。谢谢啦

sql sever语句：select * from (select top 10 * from ( select sum(number) as amount,ISBN from tb_Order_detail group by ISBN )as tab order by amount desc) o inner join tb_bookinfo b on o.ISBN=b.ISBN order by o.amount desc

Answer 1

select * .
from (select * from ( select sum(number) as amount,ISBN from tb_Order_detail group by ISBN )as tab order by amount desc limit 0, 10) o
inner join tb_bookinfo b on o.ISBN=b.ISBN order by o.amount desc

追问

[Err] 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 '.
from (select * from ( select sum(number) as amount,ISBN from tb_Order_detail ' at line 1