row_number中null

回答: 在row_number()函数中，如果排序列包含null值，这些null值会被视为最小值，即排在最前面。如果你希望将null值排在最后，可以使用coalesce函数将null值转换为一个较大的值，例如将null替换为一个足够大的数字。这样，在排序时null值就会排在最后。另外，如果在分组中存在null值，使用row_number()函数时会将这些null值都视为同一组，即它们会有相同的行号。<em>1</em><em>2</em><em>3</em>
#### 引用[.reference_title]
- *1* [Oracle中ROW_NUMBER() OVER()函数用法](https://blog.csdn.net/tnb_ml/article/details/127060633)[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^v92^chatsearchT3_1"}} ] [.reference_item]
- *2* [mysql实现row_number()和row_number() over(partition by)](https://blog.csdn.net/weixin_36168780/article/details/113593799)[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^v92^chatsearchT3_1"}} ] [.reference_item]
- *3* [MySQL中的ROW_NUMBER()](https://blog.csdn.net/weixin_39545269/article/details/113240639)[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^v92^chatsearchT3_1"}} ] [.reference_item]
[ .reference_list ]