SQL Developer for VS Code

HR Schema, 26ai version, extension v26.1.1

Query with QUALIFY (I know that it is not the best query ever and we shouldnt use qualify like that but the results of the query should be the same no matter which tool we choose :D )

select  department_id, last_name, salary
from employees
qualify salary > 15000;

If I run it as as script the results are fine

DEPARTMENT_ID LAST_NAME                     SALARY
------------- ------------------------- ----------
          90 King                          24000
          90 Yang                          17000
          90 Garcia                        17000

     But if I run it as a query - all rows are fetched

BUT If I run it as a query but highlight a commented line, the results will be fine.

-- qualify
select  department_id, last_name, salary
from employees
qualify salary > 15000;