Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle MAX function to HiRDB

MAX function without over clause

HiRDB database supports MAX function without over clause. SQLWays leaves it as is.

Oracle:

n:=max(a); 

HiRDB:

SET n = max(a); 

MAX function with over clause

HiRDB hasn't equivalent for MAX function with over clause. SQLWays leaves it as is and adds message /*Сould not convert 'max'*/.

Oracle:

n:= max([DISTINCT] a) over (partition by b);  

HiRDB:

SET n= max([DISTINCT] a) over (partition by b);
/*Сould not convert 'max'*/

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.