只要我们在嵌套子查询视图里面加入:top 100 percent即可
例如:
select * from (
select top 100 percent * from tb order by col desc
) as a order by col desc
只要我们在嵌套子查询视图里面加入:top 100 percent即可
例如:
select * from (
select top 100 percent * from tb order by col desc
) as a order by col desc
转载于:https://www.cnblogs.com/shy1766IT/p/7197714.html