Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle MIN function to HiRDB

MIN function without over clause

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

Oracle:

n:= min([ALL | DISTINCT] a);  

HiRDB:

SET n= min([ALL | DISTINCT] a);  

MIN function with over clause

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

Oracle:

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

HiRDB:

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

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