Table of Contents
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'*/