title: How to use GROUP BY on a CLOB column with Oracle?
body: <p>I'm trying to combine the <code>GROUP BY</code> function with a MAX in oracle. I read a lot of docs around, try to figure out how to format my request by Oracle always returns: </p>
  
  <blockquote>
    <p>ORA-00979: "not a group by expression"</p>
  </blockquote>
  
  <p>Here is my request:</p>
  
  <pre><code>SELECT A.T_ID, B.T, MAX(A.V) 
  FROM bdd.LOG A, bdd.T_B B
  WHERE B.T_ID = A.T_ID
  GROUP BY A.T_ID
  HAVING MAX(A.V) &lt; '1.00';
  </code></pre>
  
  <p>Any tips ?</p>
  
  <p><strong>EDIT</strong> It seems to got some tricky part with the datatype of my fields.</p>
  
  <ul>
  <li><code>T_ID</code> is <code>VARCHAR2</code></li>
  <li><code>A.V</code> is <code>VARCHAR2</code> </li>
  <li><code>B.T</code> is <code>CLOB</code></li>
  </ul>