只需一步,快速开始
扫一扫,访问微社区
有一张表A,现需要按cell_code,ne_code字段分组,按cell_alarm_type降,cell_alarm_sub_type升序,取每组的第一条数据,oralcek可以利用row_number()over(partiton by cell_code,ne_code order by cell_alarm_type,c ...
MySQL微社区
|申请友链|小黑屋|Archiver|手机版|MySQL社区 ( 京ICP备07012489号 ) 联系人:周生; 联系电话:13911732319
GMT+8, 2024-5-16 19:19 , Processed in 0.065463 second(s), 27 queries , Gzip On.
Powered by Discuz! X3.2
© 2001-2013 Comsenz Inc.