有一张表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,cell_alarm_sub_type )来做,但是mysql不知道怎么取,求各位指点迷津,sql或存储过程都行,表中数据如图
有一张表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,cell_alarm_sub_type )来做,但是mysql不知道怎么取,求各位指点迷津,sql或存储过程都行,表中数据如图
ne_code ,
MAX(cell_alarm_type) AS cell_alarm_type ,
MIN(cell_alarm_sub_type) AS cell_alarm_sub_type
FROM A
GROUP BY cell_code ,
ne_code;
[征集]分组取最大N条记录方法征集,及散分....
当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html8、如何给分和结贴?
http://bbs.csdn.net/help#post_dispose