title: select top 5 with rank - all results are rank 1
body: <p>When I perform the below query, all 5 records returned have a rank "1"... but I need to have the record with the highest count be "1", then "2", etc....</p>
  
  <p>I've tried variations of the below query, using different columns in the OVER(), etc... no luck.</p>
  
  <pre><code>SELECT TOP(5)
      SearchTerm,
      Category,
      count(''),
      RANK() OVER(PARTITION BY SearchTerm ORDER BY count('') DESC)
  
  FROM 
      Searches
  
  GROUP BY SearchTerm, Category
  ORDER BY count('') desc
  </code></pre>