Microsoft SQL ServerPagination

Introduction

Row Offset and Paging in Various Versions of SQL Server

Syntax

  • SELECT * FROM TableName ORDER BY id OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;

Related Examples

Pagination using ROW_NUMBER with a Common Table Expression