34,575
社区成员
发帖
与我相关
我的任务
分享
select top 15 * from
(
--SELECT top (15 * 1) cu.PK_ID, 一页显示15条,这样写不管是多少页数据是一样的。
--另:PK_ID与所有的外链键全是uniqueidentifier类型
SELECT top (15 * 1) cu.PK_ID,
cu.CustomerName,
pro.ProvinceName AS Province,
cu.Phone,
cu.CreateTime,
cu.UpdateTime,
cu.FK_System_UserID,
cu.Address,
cu.SiteURL,
cu.Remark,
cu.CustomerType,
cu.STATUS,
cu. ProvinceId,
cu.CityId,
dicType.Name AS CustomerTypes,
dicStatu.Name as STATUSS
FROM dbo.Customer AS cu
LEFT JOIN dbo.SystemDictionary AS dicType
ON cu.CustomerType=dicType.PK_ID
LEFT JOIN dbo.SystemDictionary AS dicStatu
ON cu.Status=dicStatu.PK_ID
LEFT JOIN dbo.Province AS pro ON cu.ProvinceId=pro.PK_ID
where 1=1 order by cu.UpdateTime desc
) AS TempTable ORDER BY TempTable.UpdateTime desc
SELECT Identifier ,
ROW_NUMBER() OVER ( ORDER BY UpdateTime DESC ) AS RowIndex --这里写成时间排序
INTO #tb1_1
FROM tablename
SELECT Identifier ,
ROW_NUMBER() OVER ( ORDER BY Identifier DESC ) AS RowIndex
INTO #tb1_1
FROM tablename
SELECT Identifier
INTO #tb1_2
FROM #tb1_1 AS t
WHERE t.RowIndex > ( @CurrentPage - 1 ) * @PageSize
AND t.RowIndex <= @CurrentPage * @PageSize
SELECT *
FROM tablename
WHERE a.Identifier IN ( SELECT *
FROM #tb1_2 )
ORDER BY Identifier DESC
DROP TABLE #tb1_1
DROP TABLE #tb1_2