一、除非同时指定了 TOP,否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。
select top 2 * from(select * from tblname order by id desc) as t --此代码会报以上错误
加 top 100 percent就可以了,例如
select top 2 * from(select top 100 percent * from bk_books order by bookid desc) as t
select top 2 * from(select * from tblname order by id desc) as t --此代码会报以上错误
select top 2 * from(select top 100 percent * from bk_books order by bookid desc) as t