title: How can I perform a SELECT DISTINCT on all fields except a BLOB?
body: <p>I'm trying to perform a SELECT DISTINCT query in Oracle, like this:</p>
  <pre><code>SELECT 
      MOVIES.TITLE, CERTIFICATIONS.ID, PROJECTION.DAY, TIME_SLOTS.SLOT, 
      PROJECTION.REMAINING_SEATS, IMAGES.IMAGE 
  FROM 
      [...]
  </code></pre>
  <p>It doesn't work because the column &quot;IMAGES.IMAGE&quot; is a BLOB. I would like to exclude this field from the DISTINCT (because I don't need it to be unique), and I don't know how. I also tried with a GROUP BY clause, but if I try to GROUP on all the fields except the BLOB, Oracle returns this error:</p>
  <blockquote>
  <p>ORA-00979: not a GROUP BY expression</p>
  </blockquote>
  <p>And if I add the field in the GROUP BY clause, then Oracle returns this:</p>
  <blockquote>
  <p>ORA-00932: inconsistent datatypes: expected - got BLOB</p>
  </blockquote>
  <p>What can I do?</p>