今天用到了几个函数,随手记一下
group by rollup();
group by cute();
select dense_rank() over(partition by t.activity_type order by t.day_cg_ratio desc) day_pm,
----dense_rank() 联系排序
---rank() 跳跃排序
---sys_connect_by_path(col,''); select type,type_p,sale,sol,sys_connect_by_path(type,'-') from wd_test t start with sale=1 connect by prior type=type_p --实现结果