Limiting rows in SQL

Hi,

By default my SQL is limiting to 100k records. Is there a way that we can remove that limit or increase the limit to 1M records?

Even after changing the rows limit to 1Million in all the places as show in below article, results are displaying only for 100k records.

Could someome please help me?