title: How to use Oracle analytic partition by with "greater than" expression?
body: <p>Oracle documentation says I can use:</p>
  
  <pre><code>select avg(id) over (partition by &lt;expression&gt;) from table1;
  </code></pre>
  
  <p>For example this goes well:</p>
  
  <pre><code>select avg(id) over (partition by id) from table1;
  </code></pre>
  
  <p>But if I use "greater than" expression I got failure ORA-00907:</p>
  
  <pre><code>select avg(id) over (partition by (id &gt; 3)) from table1;
  </code></pre>
  
  <p>Where syntax of expression is documented? Can I use "greater than" expressions to partition record set?</p>