SQL语句分页
最近做项目不允许用存储过程,所以分页的时候就用了SQL语句。
如下:
declare @Count int
declare @Page int
set @Count = 10
set @Page = 2
select top(@Count) FEBId,FPName,FETName,FEBOrderSerial,FEBState,FEBEventDate
from (
select FEBId,FETName,FPName,FEBOrderSerial,FEBState,FEBEventDate,ROW_NUMBER() over(order by FEBId desc)as RowNumber
from (
select FE.FEBId,FP.FPName,FET.FETName,FE.FEBOrderSerial,FE.FEBState,FE.FEBEventDate from FI_EventBase FE
inner join FI_EventType FET on FE.FEBEventTypeCode = FET.FETCode
inner join FI_Project FP on FE.FEBProjectCode = FP.FPCode
where FE.FEBRowStatus = 1 and FP.FPRowStatus = 1 and FET.FETRowStatus = 1
) as t) as Filter where Filter.RowNumber>(@Page-1)*@Count order by Filter.FEBId desc
declare @Page int
set @Count = 10
set @Page = 2
select top(@Count) FEBId,FPName,FETName,FEBOrderSerial,FEBState,FEBEventDate
from (
select FEBId,FETName,FPName,FEBOrderSerial,FEBState,FEBEventDate,ROW_NUMBER() over(order by FEBId desc)as RowNumber
from (
select FE.FEBId,FP.FPName,FET.FETName,FE.FEBOrderSerial,FE.FEBState,FE.FEBEventDate from FI_EventBase FE
inner join FI_EventType FET on FE.FEBEventTypeCode = FET.FETCode
inner join FI_Project FP on FE.FEBProjectCode = FP.FPCode
where FE.FEBRowStatus = 1 and FP.FPRowStatus = 1 and FET.FETRowStatus = 1
) as t) as Filter where Filter.RowNumber>(@Page-1)*@Count order by Filter.FEBId desc
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步