title: Top 10 results on rows obtained by UNION
body: <p>I am using MSSQL 2005 for a query, say:</p>
  
  <pre><code>SELECT * from Emp UNION ALL SELECT * from Emp2;
  </code></pre>
  
  <p>And I want to limit the final result to 10 rows.
  IF I had only the Emp table, I would say</p>
  
  <pre><code>SELECT TOP 10 * from Emp;
  </code></pre>
  
  <p>But since I have 2 tables now, I can't say SELECT TOP * on any of them, neither I can use LIMIT 10 in the end.
  Do you have any suggestion?</p>