title: Order by clause with Union in Sql Server
body: <p>I want List of party names with 1st option as 'All' from database. but i won't insert 'All' to Database, needs only retrieve time. so, I wrote this query.</p>
  
  <pre><code>Select 0 PartyId, 'All' Name
  Union
  select PartyId, Name
  from PartyMst
  </code></pre>
  
  <p>This is my Result</p>
  
  <pre><code>0   All
  1   SHIV ELECTRONICS
  2   AAKASH &amp; CO.
  3   SHAH &amp; CO.
  </code></pre>
  
  <p>when I use <code>order by Name</code> it displays below result.</p>
  
  <pre><code>2   AAKASH &amp; CO.
  0   All
  3   SHAH &amp; CO.
  1   SHIV ELECTRONICS
  </code></pre>
  
  <p>But, I want 1st Option as 'All' and then list of Parties in Sorted order.
  How can I do this?</p>