SQL Server: Offset Fetch in 5 minutes!

3 years ago
22

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 ROW FETCH FIRST 5 ROWS ONLY

Get "Evil Programmer" Merchandise here:
https://teespring.com/stores/evil-programmer

Never surf the net without a VPN. Get a great offer on Nord VPN here:
https://go.nordvpn.net/aff_c?offer_id=15&aff_id=30592&url_id=902​
Nord VPN has a "no logs" policy so all your activity is private.

Loading comments...