title: Error while retreving values from DB
body: <p>I need to get title, count and percentage from table REPORT_VIEW_PAGE. That works fine.</p>
  
  <pre><code>SELECT DISTINCT TITLE, COUNT(TITLE) AS tot, ROUND(COUNT(TITLE)/(
  SELECT COUNT(*) FROM REPORT_VIEW_PAGE), 4) AS per
  FROM REPORT_VIEW_PAGE 
  WHERE DAYCOUNT &gt; '0'
  GROUP BY TITLE
  ORDER BY TITLE ASC
  </code></pre>
  
  <p>But if tried to retrieve ID and TYPE like  </p>
  
  <pre><code>SELECT DISTINCT TITLE, ID, TYPE, COUNT(TITLE) AS tot, ROUND(COUNT(TITLE)/(
  SELECT COUNT(*) FROM REPORT_VIEW_PAGE), 4) AS per
  FROM REPORT_VIEW_PAGE 
  WHERE DAYCOUNT &gt; '0'
  GROUP BY TITLE
  ORDER BY TITLE ASC
  </code></pre>
  
  <p>i'm getting the error:</p>
  
  <blockquote>
    <p>ORA-00979: not a GROUP BY expression
    00979. 00000 -  "not a GROUP BY expression"
    *Cause:<br>
    *Action: Error at Line: 12 Column: 24</p>
  </blockquote>
  
  <p>Can anyone help.</p>