22,209
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
wenejiang 2003-04-02
- 打赏
- 举报
同楼上
pengdali 2003-04-02
- 打赏
- 举报
或：
exec('SELECT Top '+cast(@PageSize as varchar)+' * FROM T WHERE SortField NOT IN (SELECT TOP '+cast(@PageSize* @Pagei as varchar)+' SortField from T )')
exec('SELECT Top '+cast(@PageSize as varchar)+' * FROM T WHERE SortField NOT IN (SELECT TOP '+cast(@PageSize* @Pagei as varchar)+' SortField from T )')
pengdali 2003-04-02
- 打赏
- 举报
select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表
select * from #temp where ID_Num>10 and ID_Num<=20
select * from #temp where ID_Num>10 and ID_Num<=20
