Resolved: Fixed Number of Row retrieved from each of my between and And query

Hi Islam Elkhateeb,
If you look within the MySQL Workbench, there is a DROP DOWN option that allows you to choose the number of results returned.  When working on big data sets, you may not wish to have the 'entire' results listing generated (expect there may be some time savings\efficiencies, so you can set the 'Limit Rows' to any of the selections from the Drop Down option.
You can also set the DEFAULT for this through Edit\Preferences\SQL Editor\SQL Execution - Select Query Results (Limit Rows \ Limit Rows Count).  Screen shot below shows location of Drop Down option...

Kind regards,

Kev T.

Thank you so much Kev! 🌷