开窗函数函数排序一般可以用rank()函数
、desc_rank、row_number
https://blog.csdn.net/weixin_33968104/article/details/92941634?utm_medium=distribute.pc_aggpage_search_result.none-task-blog-2~aggregatepage~first_rank_ecpm_v1~rank_v31_ecpm-1-92941634.pc_agg_new_rank&utm_term=oracle%E6%8E%92%E5%BA%8F%E5%88%86%E6%9E%90%E5%87%BD%E6%95%B0&spm=1000.2123.3001.4430
https://blog.csdn.net/qq_38366006/article/details/104337061
