title: Want to learn more on NTILE()
body: <p>I was reading on RANKING function for ms sql. I understand the others function except NTILE().
  Lets say if i have this data:  </p>
  
  <pre><code>   StudentID     MARKS  
        S1           75  
        S2           83
        S3           91
        S4           83
        S5           93  
  </code></pre>
  
  <p>So if i do a <code>NTILE(2) OVER(ORDER BY MARKS desc)</code> what will be the result and why?<br>
  And what if it is a <code>NTILE(3)</code>?
  Simple explaination anyone? </p>