title: mysql query for table row range
body: <p>This might be a very basic question but I am struggling with queying the specific rows in a table based only on the row range.</p>
  
  <p>Let's say I have a table ABC where I have populated 1000 rows. Now I want a sql query so that I can fetch first 100 rows ( that is the range 1 to 100) and then the next 100 ( 101 to 200) and so on till I am done with all rows. And this should be done without querying/filtering on the table's  id or any column id.</p>
  
  <p>I am not able to figure it out as I am trained only on querying specific columns in WHERE clause so would appreciate if someone can plz help </p>