title: Can I get the position of a record in a SQL result table?
body: <p>If I do something like</p>
  
  <pre><code>SELECT * FROM mytable ORDER BY mycolumn ASC;
  </code></pre>
  
  <p>I get a result table in a specific order.</p>
  
  <p>Is there a way in SQL to efficiently find out, given a PK, what position in that result table would contain the record with my PK?</p>