title: GROUP BY ignoring an attribute
body: <p>for example I have this table:</p>
  <pre><code>itemgroup | description | price  
  A, a, 10  
  A, b, 12  
  A, c, 14  
  B, g, 11  
  B, h, 16  
  </code></pre>
  <p>I want to select the rows with the highest price in one group like this:</p>
  <pre><code>A, c, 14  
  B, h, 16  
  </code></pre>
  <p>The SQL query (is fully functional) which gets me near this is:</p>
  <pre><code>SELECT itemgroup, MAX( price ) 
  FROM table
  GROUP BY itemgroup
  </code></pre>
  <pre><code>A, 14  
  B, 16
  </code></pre>
  <p>By trying this I get an  &quot;not a GROUP BY expression&quot;-error:</p>
  <pre><code>SELECT itemgroup, description, MAX( price ) 
  FROM table
  GROUP BY itemgroup
  </code></pre>
  <p>I need something like this pseudo query:</p>
  <pre><code>SELECT itemgroup, IGNORE( description), MAX( price ) 
  FROM table
  GROUP BY itemgroup
  </code></pre>
  <p>I hope I could explain my little problem.</p>