用到的SQL语句
With Temptbl AS
(
Select ROW_NUMBER() Over (Order By [SendingTime] Desc) as Num,* from tb_lxbx @whereStatement
)
Select * From Temptbl
where Num between @StartIndex and @EndIndex
用到的SQL语句
With Temptbl AS
(
Select ROW_NUMBER() Over (Order By [SendingTime] Desc) as Num,* from tb_lxbx @whereStatement
)
Select * From Temptbl
where Num between @StartIndex and @EndIndex