Oracle 中row_number()

在Oracle中，row_number()是一种窗口函数，用于为查询结果集中的每一行分配一个唯一的行号。它的语法是ROW_NUMBER() OVER(PARTITION BY column ORDER BY column)。其中，PARTITION BY用来分区，ORDER BY用来排序。这个函数可以用来实现分页、排名等功能，通过给每一行分配一个行号进行排序和筛选。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [ORACLE 中rownum和row_number()的使用区别（可指定取sql结果集的第几个数据）](https://blog.csdn.net/dingding5205205200/article/details/102411797)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *3* [Oracle中排序函数的用法之ROW_NUMBER()/RANK()/DENSE_RANK() OVER()的区别](https://blog.csdn.net/Jason_05/article/details/90743928)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]