title: MAX() in WHERE clause
body: <p>The following sql, with the MAX aggregrate function in the WHERE clause, does not work:</p>
  
  <pre><code>  SELECT 
     ID,
     title, 
     relevance
  
    FROM
     myTable
  
    WHERE
     (relevance &lt;= MAX(relevance)/2)
  </code></pre>
  
  <p>Can anyone point me in the right direction?  myTable is a temporary table, so cannot be referenced again using a sub-query. Thanks!</p>