title: oracle order by missing right parenthesis
body: <p>I need to find the maximum number of distinct employees
  So my code is like:</p>
  
  <pre><code>select ProjName from Project where ProjId in (
  select ProjId from EmpProject 
  order by count(ProjId) desc
  group by ProjId
  where rownum&lt;=1
  );
  </code></pre>
  
  <p>But it throw an error says missing right parenthesis. 
  So could anyone told me how to fix this?</p>