Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle RANK function to HiRDB

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

Oracle:

select rank() over (partition by c1 order by c2) from t; 

HiRDB:

select rank() over (partition by c1 order by c2) from t;
/* SQLWays: Could not convert 'rank' */

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