title: MSSQL Selecting top 10 but include columns with duplicate values
body: <p>Hi I'm trying to get the top ten winners of a competition by using the score. Problem is when there are two users with the same score for example I'm only getting the top 9 in effect (should be eleven records returned if there are two top 3 scores and the rest are unique for example)... </p>
  
  <p>I'm not sure how to tackle this and would appreciate some guidance.</p>
  
  <p>Thanks in Advance,</p>
  
  <p>Ian</p>