Question

这句sql语句哪里有错误，提示“关键字 'order' 附近有语法错误。”

"select * from ( select top 10 * from Book order by bookid desc ) order by bookid asc"
为了实现选择数据库里的后十条数据，并且这十条数据也是升序排列。

Answer 1

desc) as a order by bookid asc