34,593
社区成员
发帖
与我相关
我的任务
分享
SELECT Identifier ,
ROW_NUMBER() OVER ( ORDER BY Identifier DESC ) AS RowIndex
INTO #tb1_1
FROM tablename
WHERE name LIKE '%张%'; --这里写条件
SELECT Identifier
INTO #tb1_2
FROM #tb1_1 AS t
WHERE t.RowIndex > ( @pageNo - 1 ) * @PageSize
AND t.RowIndex <= @pageNo * @PageSize;
SELECT *
FROM tablename
WHERE a.Identifier IN ( SELECT *
FROM #tb1_2 )
ORDER BY Identifier DESC;
DROP TABLE #tb1_1;
DROP TABLE #tb1_2;