Migrating Service SQL

-- The HAVING clause must be placed after the GROUP BY clause, while Oracle allows HAVING to be placed before or after the GROUP BY clause. In the target database, the HAVING clause is moved after the GROUP BY clause.
SELECT
id,
count(*),
sum(remain_users) 
FROM LYC.APEX2_DYNAMIC_ADD_REMAIN_TEST 
HAVING id <= 5
GROUP BY id;

-- The UNIQUE keyword is migrated to the DISTINCT keyword.
SELECT UNIQUE add_users FROM LYC.APEX2_DYNAMIC_ADD_REMAIN_TEST;

-- The NVL2(expression, value 1, value 2) function determines the value returned by the query based on whether the specified expression is null. If the expression is not null, then NVL2 returns value 1. If the expression is null, then NVL2 returns value 2.
SELECT NVL2(add_users, 1, 2) FROM LYC.APEX2_DYNAMIC_ADD_REMAIN_TEST WHERE rownum <= 2;