例1:
select top 100 percent * from paper
order by time desc
例2:
with
t as
(select top 100 percent * from paper
order by time desc)
select * from t
例3:
with
t as
(select top 100 percent * from paper)
select * from t order by time
其中,例1和例3得到的结果一样,但是例2得到的结果就没有对时间进行排序,
求大神看到了解释一下,最好能告诉我原理。。。