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: 
Try - 

```
SELECT first_name, salary 
(  select first_name, salary 
   from employees 
   order by salary Desc)
where rownum <= 10

```
This will work

```
select emp_id, salary from orders
order by salary desc limit 10;

```