34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT a.id ,
ROW_NUMBER() OVER ( ORDER BY a.updatedate DESC ) AS RowIndex
INTO #tb1_1
FROM T_BookDetail a
LEFT JOIN T_Book b ON a.bookid = b.id
WHERE b.name LIKE '%武%'
SELECT id
INTO #tb1_2
FROM #tb1_1 AS t
WHERE t.RowIndex BETWEEN 1 AND 100
SELECT *
FROM T_BookDetail a
LEFT JOIN T_Book b ON a.bookid = b.id
WHERE a.Id IN ( SELECT *
FROM #tb1_2 )
ORDER BY a.Id DESC
DROP TABLE #tb1_1
DROP TABLE #tb1_2