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' */