1.
select identity(int,1,1) id,* into #aa from tablename
select top 2 * from #aa where leixing='大柜' and id>=3
2.不对,试一下就知道了!
select top 2 * from #aa where leixing='大柜' and id>=9
select identity(int,1,1) id,* into #aa from tablename
select top 2 * from #aa where leixing='大柜' and id>=3
2.不对,试一下就知道了!
select top 2 * from #aa where leixing='大柜' and id>=9
select top 2 * from tablename
where bianhao not in (select top 3 from bianhao from tablename where leixing='大柜' order by bianhao)
and leixing='大柜'
order by bianhao
1.
select identity(int,1,1) id,* into #aa from tablename where leixing='大柜'
select top 2 * from #aa where id>=3
2.对,试一试
select top 2 * from #aa where id>=9
--1.
select top 2 * from #temp where leixing = '大柜' and id >= 3 and (id - 3) % 2 = 0
--2
select top 2 * from #temp where leixing = '大柜' and id >= 9 and (id - 9) % 2 = 0 drop table #temp