问在SQL中显示240张图片，每页9张

EN

SELECT *,
(ROW_NUMBER() OVER (ORDER BY person_id) -1 )/3 AS RowGrpNo,
(ROW_NUMBER() OVER (ORDER BY person_id) -1 )%3 AS ColGrpNo,
(ROW_NUMBER() OVER(ORDER BY person_id)-1)/9 AS PageGrpNo
FROM
(

SELECT DISTINCT
  People.person_id,
  People.ActivePassive,
  PeoplePicture.person_id,
  PeoplePicture.picture_id,
  PeoplePicture.Picture
  FROM People
  Right Join PeoplePicture
  On People.person_id = PeoplePicture.person_id
  WHERE People.ActivePassive = 'Active'
)t​