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