Result from a limit clause: some platforms cap rows with a prefix (TOP n), others with a suffix (LIMIT n OFFSET m, OFFSET m ROWS FETCH NEXT n ROWS ONLY).
TOP n
LIMIT n OFFSET m
OFFSET m ROWS FETCH NEXT n ROWS ONLY
SQL placed between SELECT and the column list (e.g., "TOP 10")
SQL placed after the ORDER BY / WHERE clause (e.g., "LIMIT 10 OFFSET 20")
Result from a limit clause: some platforms cap rows with a prefix (
TOP n), others with a suffix (LIMIT n OFFSET m,OFFSET m ROWS FETCH NEXT n ROWS ONLY).