Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle AVG function to HiRDB

AVG function without OVER clause

HiRDB database supports AVG function without OVER clause. SQLWays leaves it as is.

Oracle:

n:= AVG(DISTINCT a); 

HiRDB:

SET n= AVG(DISTINCT a); 

AVG function with OVER clause

HiRDB hasn't equivalents for AVG function with OVER clause. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'AVG' */.

Oracle:

n:= AVG(a) OVER(partition by b); 

HiRDB:

SET n= AVG(a) OVER(partition by b); 
/*Сould not convert 'AVG'*/

References in Wiki

Database Reference
Oracle AVG
HiRDB AVG

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