Migration MYSQL to ORACLE

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

​x
 
SELECT MIN(id) as min_id, Server_NameFROM detailsWHERE Server_Role IS NOT NULL THENGROUP BY Server_Name​

Answer

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;

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