把Select * from bbsset 当成一个表 PageingTable1就是上面这个表的一个别名相当于 Select * into PageingTable1 from bbsset Select top 2 * from PageingTable1 order by lys drop table PageingTable1
以上语句和下面语句功能相同 select top 2 * from bbsset order by lys
select top 2 * from ( select * from bbsset ) PageingTable1 order by lys 主要是“PageingTable1别名 ,作用域本语句结束
PageingTable1就是上面这个表的一个别名相当于
Select * into PageingTable1 from bbsset
Select top 2 * from PageingTable1 order by lys
drop table PageingTable1
select top 2 * from bbsset order by lys