求各位大佬帮忙做下分页查询

Question

SELECT * FROM (SELECT c.Id, ISBN, ShuMing,DingJia , ChuBanShe,ChuBanDate, H_ID,CATALOGID,b.leixing,[BookType] FROM [newdaku].[dbo].db_bookinfo_BookType a left join [huizong].[dbo].buyaoshu_type b ON a.BookType = b.id inner join [SystemDataHuanCun].[dbo].[BianMu_BaseInfo] c on a.B_ID=c.CATALOGID) AS P PIVOT (max([BookType]) FOR P.[leixing] IN ([高职],[中职],[职业教育],[成人教育],[中学],[小学],[少儿],[教材],[教辅],[试卷],[挂图],[活页],[散页],[附磁带],[大开本],[小开本],[影印版],[英文版],[经折装],[线装],[袋装],[工具书],[外文版],[少数民族语言],[纯光盘],[套书不单卖],[100页以内],[习题集],[盒装],[150页以内],[50页以内],[100元以上])) AS T

Answer 1

你可以看下这个帖子：https://www.cnblogs.com/equation/p/6405849.html