dalmat36 · August 29, 2015 13:57
diff --git a/Offset Fetch Filter b/Offset Fetch Filter
 /*OFFSET FETCH Filter 
 Offset by 5 and filter next 5 rows*/
 SELECT orderid, orderdate, custid, empid
 FROM Sales.Orders
 ORDER BY orderdate, orderid
 OFFSET  5 ROWS FETCH NEXT 5 ROWS ONLY;
	/*OFFSET FETCH Filter
	Offset by 5 and filter next 5 rows*/
	SELECT orderid, orderdate, custid, empid
	FROM Sales.Orders
	ORDER BY orderdate, orderid
	OFFSET 5 ROWS FETCH NEXT 5 ROWS ONLY;