OFFSET 0 ROWS FETCH FIRST 25 ROWS ONLY

 use Northwind
 GO

SELECT * FROM Orders
ORDER BY OrderID
OFFSET 0 ROWS FETCH FIRST 25 ROWS ONLY


效果同
SELECT TOP(25) * FROM Orders
ORDER BY OrderID

差別:
TOP不是ANSI SQL，但是TOP還可以搭配PERCENT和WITH TIES很方便
OFFSET是 ANSI SQL

ORDER BY NULLS FIRST、ORDER BY NULLS LAST

原來Oracle有這種語法，SQL Server沒有這語法
https://www.oracletutorial.com/oracle-basics/oracle-order-by/

而且是ANSI SQL:2003語法
https://en.wikipedia.org/wiki/Order_by