Mulesoft 4.2 - Anypoint Studio - How to fetch records from a database table using query parameters

[@shubhamrendalkar7569]

What will be there in select query if query params are optional?

[@asfawkuture4756]

Thank you for creating those awesome videos!!

[@advaphy6932]

Thanks

[@godtharungamer4733]

how to fetch bulk of records... i am not able to retrieve more than 1000 records from DB, even if i am using fetch count as 10000 and maximum records to 100000