Limit the number of records returned in a sql query. I.e. "SELECT TOP n" / "SELECT UP TO n" / "SELECT ... LIMIT n" type of queries.

Also "SELECT COUNT(col)" type of queries to determine the size of a full query result.

E.g. These two query forms would be needed for dividing a large dataset into multiple html pages. (Constructing a large image gallery in my case).