Assume your company has a large customer base. Assume further that you want a report on the first 100 customers to which your company made a sale. In this example, you would sort the report by customer, select Limit number of rows to on the Select Fields Query Builder page and enter 100 as the desired number of rows.
Using this example, you could also create a report on the last 100 customers in your company. To do this, you would change the order of the sort.