title: How to return top 100 rows by a column value and then randomize theese top 100 rows?
body: <p>I'm using MS SQL and i've managed to create a query that selects top 100 rows and randomize them like this </p>
  
  <pre><code>SELECT TOP 100 * FROM Inlagg  ORDER BY NEWID() 
  </code></pre>
  
  <p>I've also managed to create a query that returns the top 100 rows according to the column likes like this </p>
  
  <pre><code>SELECT TOP 100 * FROM Inlagg  ORDER BY Likes DESC
  </code></pre>
  
  <p>My question is now, how can i target theese top 100 rows by Likes and then randomize theese top 100 values? </p>
  
  <p>Any help or input highly appreciated, thanks! </p>