A way to cap the rows a query returns: 'top' (SELECT TOP n), 'limit-offset' (LIMIT n OFFSET m) or 'offset-fetch' (OFFSET m ROWS FETCH FIRST n ROWS ONLY).
'top'
SELECT TOP n
'limit-offset'
LIMIT n OFFSET m
'offset-fetch'
OFFSET m ROWS FETCH FIRST n ROWS ONLY
A way to cap the rows a query returns:
'top'(SELECT TOP n),'limit-offset'(LIMIT n OFFSET m) or'offset-fetch'(OFFSET m ROWS FETCH FIRST n ROWS ONLY).