select top (30) id,shijian,tupian,biaoti from (select ROW_NUMBER() over(order by [id] desc) as rowid ,* from [wen] where xiaoleiid in(1,2,3,4,5))as A where rowid>(30*(0))
以前都是用這條SQL 查詢分頁的 速度還是可以的 但是我現在要多表查詢了 要加上 發布者的名字 頭像 以及 分類 這些都是保存id
要加上 (wen INNER JOIN [user] ON wen.userid=[user].id) INNER JOIN xiaolei ON wen.xiaoleiid=xiaolei.id
變成 查詢
select top (30) wen.id,wen.shijian,wen.tupian,wen.biaoti,[user].touxiang,[USER].ming,xiaolei.id as id2,xiaolei.ming as ming2 from (select ROW_NUMBER() over(order by [id] desc) as rowid ,* from [wen] where xiaoleiid in(1,2,3,4,5))as A where rowid>(30*(0))
..我要在哪里加啊。。。大佬們
uj5u.com熱心網友回復：
這樣嗎？SELECT TOP (30)
id,
shijian,
tupian,
biaoti
FROM
(
SELECT
ROW_NUMBER() OVER (ORDER BY
[id] DESC
) AS rowid,
*
FROM
(wen
INNER JOIN
[user]
ON wen.userid = [user].id)
INNER JOIN
xiaolei
ON wen.xiaoleiid = xiaolei.id
WHERE
xiaoleiid IN (
1, 2, 3, 4, 5
)
) AS A
WHERE
rowid > (30 * (0));
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/94762.html
標籤：基礎類
上一篇：這是什么情況