How to narrow drown search by multiple criteria

my query is

but can I retrieve only upto 1000. I want to narrow down the search by specifying column attributes for example date_of_cessation between 2 dates so that i can do multiple searches and combine to get the total results. This will also reduce the load on the server and enhanced response time.