title: How to retrieve specific rows from SQL Server table?
body: <p>I was wondering is there a way to retrieve, for example, 2nd and 5th row from SQL table that contains 100 rows?</p>
  
  <p>I saw some solutions with <code>WHERE</code> clause but they all assume that the column on which <code>WHERE</code> clause is applied is linear, starting at 1.</p>
  
  <p>Is there other way to query a SQL Server table for a specific rows in case table doesn't have a column whose values start at 1? </p>
  
  <p>P.S. - I know for a solution with temporary tables, where you copy your select statement output and add a linear column to the table. I am using T-SQL</p>