title: How to use OFFSET and Fetch without Order by in SQL Server
body: <p>I want use OFFSET and Fetch in my SQL server 2012 query.But without any order by.I can not use order by.Because my sort order will be lost.
  How can I use OFFSET and Fetch without order by and row number and where in my query?
  My 2 select tables have same structure.</p>
  
  <pre><code>INSERT INTO @TempTable [some columns]  
  select [some columns] from table1 order by col1 
  INSERT INTO @TempTable [same columns]
  select [some columns] from table2 order by col2
  select * from @TempTable OFFSET 20 ROWS FETCH NEXT 50 ROWS ONLY
  </code></pre>
  
  <p>This query has syntax error at OFFSET keyword.</p>