具体使用参见
https://blog.csdn.net/qq_25221835/article/details/82762416
select policyno,zyempno,row_number() over(partition by policyno order by zytime desc) rank from dy_zywater
具体使用参见
https://blog.csdn.net/qq_25221835/article/details/82762416
select policyno,zyempno,row_number() over(partition by policyno order by zytime desc) rank from dy_zywater