Actual Practise : Row_Number() over(partition by colnum1 order by colnum2 ) as No - 7

最新推荐文章于 2022-12-12 15:32:20 发布

LitteBB

最新推荐文章于 2022-12-12 15:32:20 发布

阅读量1.7k

点赞数

分类专栏： SQL 文章标签： row-number

本文链接：https://blog.csdn.net/u011894964/article/details/51145224

版权

本文通过实例讲解如何利用Row_Number() over(partition by colnum1 order by colnum2)来展示每个贷款记录的最大ID。通过为每个贷款分组并按colnum2排序，为每条记录添加编号，以便于识别和操作记录。

摘要由CSDN通过智能技术生成

Let us see a requirement :
we need show the Max(ID) of each loan record however each loan has one more records.
这里写图片描述
How will we do?
The best and the first way is :

Let me show you by Row_Number() Over(partition by colnum1 order by colnum2) as No to make it effective.

;with cte as
(
select Row_number() over (partition by servicerloannumber order by hmpmodificationdataid desc) as no, * from hmpmodificationdata 
where servicerloannumber in