select * from (select top 10 * from tableName ) order by id desc 要加一个别名select * from (select top 10 * from tableName ) a order by id desc
from tableName) orde 加空格
