title: how to limit and order by in MS SQL?
body: <p>I'm familiar with MySQL but not in MS SQL, </p>
  
  <p>In MySQL the query will be like this: </p>
  
  <pre><code>SELECT * from tablename ORDER BY RAND() LIMIT 5
  </code></pre>
  
  <p>The above query gives a 5 random number of result from the table. The same query how can i do with MS SQL?</p>