row_number() over(order by 1)
时间: 2023-09-13 14:07:19 浏览: 51
row_number() over(order by 1)是一种在SQL中使用的函数,用于对结果集中的行进行编号。在order by子句中,使用数字1表示按第一列进行排序。这意味着结果集将按照第一列的值进行排序,并为每一行分配一个唯一的编号。这个函数通常用于分析和排名数据,可以根据不同的排序需求进行灵活的调整。使用row_number() over(order by 1)可以方便地对结果集进行排序并为每一行分配一个序号。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [sql ROW_NUMBER() 排序函数](https://blog.csdn.net/weixin_34111819/article/details/86087470)[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%"]
- *2* *3* [SQL Server中ROW_NUMBER()函数的使用](https://blog.csdn.net/pan_junbiao/article/details/79941162)[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 ]