Thanks Joe,🙂

I got it and modified based on order by offset,

Can you help me for how to do for multiple tables?

DECLARE @iterator INT = 0
DECLARE @batch INT = 10
declare @n int = (SELECT COUNT(1) FROM Table1)
WHILE @iterator< @n
BEGIN
  SELECT *
  FROM Table1
  ORDER BY Id
  OFFSET @iterator ROWS
  FETCH NEXT @batch ROWS ONLY

  SET @iterator +=@batch

END