title: "order by newid()" - how does it work?
body: <p>I know that If I run this query</p>
  
  <pre><code>select top 100 * from mytable order by newid()
  </code></pre>
  
  <p>it will get 100 random records from my table.</p>
  
  <p>However, I'm a bit confused as to how it works, since I don't see <code>newid()</code> in the <code>select</code> list. Can someone explain? Is there something special about <code>newid()</code> here?</p>