title: Returning distinct prioritizing results with order by
body: <pre><code>Name varchar, Value int, Active bit
  -----------------------------------
  'Name1',1,1
  'Name2',2,1
  'Name1',3,0
  'Name2',4,0
  'Name3',1,1
  'Name4',1,1
  </code></pre>
  
  <p>I want to return where <code>Active</code> is anything but prioritize when it's <code>0</code> so I want to return this:</p>
  
  <pre><code>'Name1',3
  'Name2',4
  'Name3',1
  'Name4',1
  </code></pre>
  
  <p>I tried this, but get an error to include <code>Active</code> in my return statement</p>
  
  <pre><code>Select Distinct Name, Value From Table Order by Active
  </code></pre>
  
  <p>So I tried this:</p>
  
  <pre><code>Select Distinct Name, Value, Active From Table Order by Active
  </code></pre>
  
  <p>But now it returns all the rows.  I would like to prioritize <code>where Active = 0</code> in the distinct results but since it requires I put <code>Active</code> in the return statement makes this complicated.</p>
  
  <p>Can someone help?</p>