title: Select top 10 salary from employees table
body: <p>I wrote this sql query: </p>
  
  <pre><code>select first_name, salary 
  from employees 
  where salary in( select distinct top(10) salary from employees order by salary  disc );
  </code></pre>
  
  <p>When I ran it, I got this error:</p>
  
  <p>SQL Error: ORA-00907: missing right parenthesis
  00907. 00000 -  "missing right parenthesis"</p>
  
  <p>What could have caused the error?</p>