title: Can this query be modified to include an offset?
body: <p>Currently using an Excel form with some basic VBA to pass data between end users and a SQL table.  I'm running into a bit of a problem though, where the users may wish to skip the record they're being presented, and get the next one.  Because I've got 3 users (currently) sharing the data, I need to be sure Person A and Person B aren't conflicting each other.  I do this by updating a status field to "LOCKED" as soon as User A receives her data.</p>
  
  <p>Anyway, I've been trying to figure out how the OFFSET works, but am not having much luck.</p>
  
  <p>The abridged version of the statement:</p>
  
  <pre><code>Select top 1 ID,Query,Status from mydb.mytable where status = 'NEW' order by Priority desc 
  </code></pre>
  
  <p>That gives me the highest priority record in NEW status.  A second statement runs to update "NEW" to "LOCKED"</p>
  
  <p>But if the user can't handle the record, she needs a different one.  I thought something like the below would work, but I just can't get it to work.</p>
  
  <pre><code>Select top 1 ID,Query,Status from mydb.mytable where status = 'NEW' order by Priority desc offset 5;
  </code></pre>
  
  <p>Thank you for any help!</p>