query paging

querypaging.sql

-- returning the first 25 rows
SELECT
  e.FirstName,
  e.LastName,
  e.AddressLine1

FROM 
  HumanResources.vEmployee AS e
  
ORDER BY
  e.LastNAme, e.FirstName
  OFFSET 0 ROWS
  FETCH NEXT 25 ROWS ONLY;
    
-- paging through the next 25 rows
SELECT
  e.FirstName,
  e.LastName,
  e.AddressLine1

FROM 
  HumanResources.vEmployee AS e
  
ORDER BY
  e.LastNAme, e.FirstName
  OFFSET 24 ROWS
  FETCH NEXT 25 ROWS ONLY;