在Sqlserver分组中加入行号

发布时间：2020-12-12 15:50:49 所属栏目：MsSql教程来源：网络整理

导读：select *,row_number() over (partition by msisdn,imsi order by msisdn,imsi desc) rn into #tt from T_msisdn_imsi_tac_manufacturer_location ? select * into #ttt from #tt where rn12

select *,row_number() over (partition by msisdn,imsi
order by msisdn,imsi desc) rn
into #tt from T_msisdn_imsi_tac_manufacturer_location

select * into #ttt from #tt where rn<12

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!