62,046
社区成员
发帖
与我相关
我的任务
分享帮写一条SQL 别
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))
..我要在哪里加啊。。。大佬们
以前都是用这条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))
..我要在哪里加啊。。。大佬们
...全文
请发表友善的回复…
发表回复
吃瓜农 2019-12-06
- 打赏
- 举报
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] 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))
