OFFSET @paramOffset ROWS FETCH NEXT @paramLimit ROWS ONLY; code example

Example: offset rows fetch next

ORDER BY column_list [ASC |DESC]
OFFSET offset_row_count {ROW | ROWS}
FETCH {FIRST | NEXT} fetch_row_count {ROW | ROWS} ONLY
Code language: SQL (Structured Query Language) (sql)