CODEWITHSUNDEEP
sqloracle-sqldeveloperoracle12c
vimal kumar
vimal kumar

Reputation: 325

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

Upvotes: 0

Views: 84

Answers (1)

shubhamr238
shubhamr238

Reputation: 1408

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;

Upvotes: 2

Related Questions