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;