sqlserer 多表通用分页查询

 

 

 

 declare 
@pageIndex int=2, ------页码
@pageSize int=100;-----每页数量
select 
	top (@pageSize) * 
from 
(      
    -----------这里写要查询的结果sql,多表单表通用
      
	select 
		row_number() over(order by F_CreateTime desc) as rownumber,* 
	from ( SELECT s1.*  FROM 
[Iot_DeviceAlarmInfo]   s1  Inner JOIN [Iot_OpenidDeviceInfo]  s2  
ON  ( s1.F_OpenidDeviceInfoId  = s2.F_Id )   
WHERE 1=1  AND  s2.F_IsDelete=0  
and s2.F_OpenID='ok3Zo63P5CHU8GAKMqTs1cde7cYk' 
  ) d
) as a
where 
a.rownumber>((@pageIndex-1)*@pageSize) order  by  F_CreateTime  desc;