Migration MYSQL to ORACLE

Question

right now am working on database migration from MYSQL TO ORACLE.

I have experience in MySQL but not in Oracle, So help me to convert the following MYSQL query to ORACLE

Mysql query:

SELECT MIN(id) as min_id, Server_Name
FROM details
WHERE Server_Role IS NOT NULL THEN
GROUP BY Server_Name

Answer 1

Try this
Just Don't use the THEN clause its not needed.

SELECT MIN(id) AS "min_id", Server_Name 
FROM details 
WHERE Server_Role IS NOT NULL
GROUP BY Server_Name;