SQL Server: Offset Fetch in 5 minutes!

First published at 22:12 UTC on February 27th, 2021.
subscribers

In this video, I show you how to use Offset and Fetch in SQL Server.

AdventureWorks2017 Query:
USE AdventureWorks2017;
GO

SELECT
PurchaseOrderID,
OrderDate,
SubTotal,
ModifiedDate
FROM
Purchasing.PurchaseOrderHeader
ORDER BY
SubTotal DESC

OFFSET 10 …

MORE
CategoryScience & Technology
SensitivityNormal - Content that is suitable for ages 16 and over
DISCUSS THIS VIDEO