SET ROWCOUNT option limits the volume of rows that return from a question. When we established SET ROWCOUNT as 4 for the following question, it procedures The full query but only returns 4 rows. SET ROWCOUNT selection overrides the TOP search term, if the set price of the ROWCOUNT is smaller comp