title: Put cursor.fetchone to specific row?
body: <p>I'm working on a project where I need to get data from my SQL Server, but there is a catch. In total there is around 100.000 rows in the specific column I need the data out of but I only need the last 20.000 - 30.000 rows of it.</p>
  <p>I use the casual connection string and stored procedure but is there a way to select a specific row to start from? (for example let it start at row 70.000)</p>
  <pre><code>try:
      CONNECTION_STRING = 'DRIVER='+driver+';SERVER='+server+';DATABASE='+databaseName+';UID='+username+';PWD='+ password
  
      conn = pyodbc.connect(CONNECTION_STRING)
  
      cursor = conn.cursor()
      storedproc = &quot;*&quot;
      cursor.execute(storedproc)
      row = cursor.fetchone()
      while row:
          
          OID = ((int(row[1])))
          print(OID)
  </code></pre>
  <p>So my question: is there a way (for example) set <code>cursor.fetchone</code> to row 70.000 instead of 1? Or is there another way to do that?</p>
  <p>Thanks in advance!</p>