I was reading on RANKING function for ms sql. I understand the others function except NTILE(). Lets say if i have this data: 

   StudentID     MARKS  
      S1           75  
      S2           83
      S3           91
      S4           83
      S5           93

So if i do a NTILE(2) OVER(ORDER BY MARKS desc) what will be the result and why?
And what if it is a NTILE(3)? Simple explaination anyone?

sql sql-server sql-server-2008 t-sql
Edit
Report