title: Sql server select group by order by different field
body: <p>I have a table:</p>
  
  <pre><code>Id    Date        color
  ------------------------- 
   1    23/04/2013  red
   2    23/04/2013  white
   3    23/04/2013  yellow
   4    23/04/2013  red
   5    23/04/2013  orange
   6    23/04/2013  blue
   7    23/04/2013  yellow
   8    23/04/2013  red
  </code></pre>
  
  <p>I group by color and order by total and color:</p>
  
  <pre><code>Select top 5 color, count(color) as total from table where Date&lt;=getdate() group by color order by total desc, color asc
  </code></pre>
  
  <p>So until herer, all is ok.</p>
  
  <p>Now, I would want the same, but NOT ordering by color. I want to order by total, and then, by date. But I don't want to group by date.</p>