select * from (select ALARMID,BRNUMBER,STATUS,ALARMTYPE,RECIVETIME,ALARMTIME,ROW_NUMBER() over(partition by ALARMTYPE order by ALARMID) as new_index from BJ_ELEALARM) a where a.new_index=1
分组查询显示每一组的第一条
最新推荐文章于 2024-04-24 13:27:31 发布