sarpay
5/16/2013 - 12:52 PM

[sql] paginated select query

[sql] paginated select query

SELECT
  [ID]
  ,[Question]
  ,[RightAnswer]
FROM
  [QUESTIONS]
WHERE
  [QuizID]=@QuizID
ORDER BY
  [ID]

OFFSET @SkipCount ROWS
FETCH NEXT 1 ROWS ONLY