Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle DENCE_RANK function to HiRDB

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

Oracle:

select dense_rank() over(partition by col1 order by col2) from t; 

HiRDB:

select dense_rank() over(partition by col1 order by col2) from t;
/* SQLWays: Could not convert 'dense_rank' */

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