title: Error in using aggregate function max() oracle
body: <p>I am trying to run query</p>
  
  <pre><code>select * from OS_Historystep where step_name = '011' and finish_date = max(finish_date) ;
  </code></pre>
  
  <p>But i am getting error that </p>
  
  <pre><code>ORA-00934: group function is not allowed here
  00934. 00000 -  "group function is not allowed here"
  *Cause:    
  *Action:
  Error at Line: 12 Column: 72
  </code></pre>
  
  <p>what i am doing wrong?</p>
  
  <p>Thanks</p>