Skip to content
Advertisement

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

Advertisement

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;
User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement