SET ROWCOUNT selection boundaries the amount of rows that return from a query. When we set SET ROWCOUNT as 4 for the next question, it procedures the whole query but only returns 4 rows.Established ROWCOUNT option overrides the TOP key phrase, In the event the established worth of the ROWCOUNT is smaller than the Major expression, the returned quan