如果
feld1在
feld0分区中是唯一的，则可以：
select *, ( select count(*) from YourTable yt2 where yt2.feld0 = yt1.feld0 -- Same partition and yt2.feld1 <= yt1.feld1 -- Lower or equal rank ) as rankingfrom YourTable yt1
如果
feld1在
feld0分区中是唯一的，则可以：
select *, ( select count(*) from YourTable yt2 where yt2.feld0 = yt1.feld0 -- Same partition and yt2.feld1 <= yt1.feld1 -- Lower or equal rank ) as rankingfrom YourTable yt1
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
