sql 分页

佚名 6年前 (2019-04-19) 随笔 1057人围观抢沙发百度已收录

DECLARE @PageIndex INT=1;
DECLARE @PageSize INT=10;

SRE实战互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

SELECT COUNT(1) As SumCount,@PageIndex AS PageIndex,@PageSize AS PageSize FROM (

--主体内容--

SELECT GeneralID,Title,NodeID,Area_Province,Area_City,Price,Hits,Status,ISNULL(Editor,'') AS Editor FROM dbo.PE_CommonModel INNER JOIN dbo.PE_U_SecondHand ON GeneralID=ID

) A;

SELECT * FROM (
SELECT TOP (@PageIndex*@PageSize) ROW_NUMBER() OVER (ORDER BY GeneralID desc) PageNumber,* FROM (

--主体内容--

SELECT GeneralID,Title,NodeID,Area_Province,Area_City,Price,Hits,Status,ISNULL(Editor,'') AS Editor FROM dbo.PE_CommonModel INNER JOIN dbo.PE_U_SecondHand ON GeneralID=ID

)
A) A WHERE PageNumber>((@PageIndex-1)*@PageSize);