title: SQL - Order to 3 results
body: <p>I have little question. How to do in SQL server sorting and return it to variables (outputs)
  I know how can I do this in MySQL, but not sure about MSSQL,since there isn´t limit function.
  For example : </p>
  
  <pre><code>DECLARE @dwFirst = SELECT * FROM RANK ORDER BY dwPoints DESC (WHERE dwPoints will be best)
  DECLARE @dwSecond, etc.
  </code></pre>
  
  <p>Edit : Thanks, but this SELECT TOP works just for one result.</p>
  
  <p>21000 - [SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &lt;, &lt;= , >, >= or when the subquery is used as an expression.</p>
  
  <p>It says when I use TOP 2, etc.</p>
  
  Thanks!