title: SQL Query: How can I get data of row with number 1000 direclty?
body: <p>If I have a SQL Table called <code>Persons</code> that contain about 30000 rows and I want to make a SQL query that retrieve the data of row number 1000 ... I got it by non professional way by making the following query    </p>
  
  <pre><code>Select Top 1 * from 
  (
      Select top 1000 *
      From Persons
      Order By ID 
  )A
  Order By A.ID desc
  </code></pre>
  
  <p>But I feel that's a more optimized query that can do that ... can any lead me to perfect query ?<br>
  Note : table contain PK column called "ID" but it's not sequential</p>