select px = identity(int,1,1),* into # from taselect * from # where px between 30 and 40
select aa=identity(int,1,1),* into # from tt select top 10 * from # where aa>=30
能不能具体解释下 select px = identity(int,1,1),* into # from ta 小弟新手,不懂其含义。谢谢啦
select top 10 * from tab where id not in (select top 30 id from tab order by id ) order by id select top 10 * from tab where id in (select top 40 id from tab order by id) order by id desc
from #
where px between 30 and 40
select top 10 * from # where aa>=30
小弟新手,不懂其含义。谢谢啦
select top 10 * from tab
where id not in (select top 30 id from tab order by id )
order by id
select top 10 * from tab
where id in (select top 40 id from tab order by id)
order by id desc