sqlserver带多表查询的分页

kirsten

SELECT  s.Id as Id,s.Name as Name,avg(s.Phone) as Phone   FROM dbo.OrganizationPoint AS o
INNER JOIN  [dbo].[Employment] AS e ON o.OrganizationId=e.EmployingUnitId
INNER JOIN dbo.Student AS s ON s.Id =e.StudentId
INNER JOIN dbo.Major AS m ON s.MajorId = m.Id
inner join dbo.Organization as j on j.Id = e.EmployingUnitId
left join Organization o1 on m.collegeId=o1.Id or o1.Id=4 or o1.parentId=4
where j.DistrictCode like '51%'
group by s.Name,s.Id


求助  这种该如何分页

站长苏飞

select * from(

SELECT  s.Id as Id,s.Name as Name,avg(s.Phone) as Phone   FROM dbo.OrganizationPoint AS o
INNER JOIN  [dbo].[Employment] AS e ON o.OrganizationId=e.EmployingUnitId
INNER JOIN dbo.Student AS s ON s.Id =e.StudentId
INNER JOIN dbo.Major AS m ON s.MajorId = m.Id
inner join dbo.Organization as j on j.Id = e.EmployingUnitId
left join Organization o1 on m.collegeId=o1.Id or o1.Id=4 or o1.parentId=4
where j.DistrictCode like '51%'
group by s.Name,s.Id

) as t 这样不就和了，下面应该怎么写就怎么写

songwenqi

站长的想法很好啊   支持！！！！

kirsten

谢谢楼主  ，好机智，好机智