Question: I wrote this sql query: 

```
select first_name, salary 
from employees 
where salary in( select distinct top(10) salary from employees order by salary  disc );

```

When I ran it, I got this error:

SQL Error: ORA-00907: missing right parenthesis
00907. 00000 - "missing right parenthesis"

What could have caused the error?

Answer: 
The below Query works in Oracle.

select \* from (select \* from emp order by sal desc) where rownum<=10;
Try this ===
 SELECT first\_name, salary FROM employees WHERE salary IN (SELECT salary FROM employees GROUP BY salary ORDER BY salary DESC LIMIT 10);