Convert Oracle SQL to Snowflake

Oracle to Snowflake keeps || and NVL but replaces ROWNUM paging with QUALIFY / LIMIT and SYSDATE with CURRENT_TIMESTAMP(). A mechanical formatter only re-indents — it won’t rewrite dialect-specific syntax. The AI converter in the app translates the query and the table below shows exactly what changes.

SELECT e.dept_id, e.employee_id, e.salary
FROM (
  SELECT e.*, ROWNUM rn
  FROM employees e
  ORDER BY e.salary DESC
) e
WHERE rn <= 5;

SELECT e.dept_id, e.employee_id, e.salary
FROM employees e
QUALIFY ROW_NUMBER() OVER (ORDER BY e.salary DESC) <= 5;