如果只取第一行,为:select top 1 * from yourtable如果想取指定一行,则:select identity(int,1,1) as idd,* into #t from yourtable
select * from #t where idd=9
select * from #t where idd>=9 and idd<=20
drop table #t
select * from #t where idd=9
select * from #t where idd>=9 and idd<=20
drop table #t
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货