Int_Xu的博客

获取不同类型的操作流水中最后一条SELECT a.* FROM ( SELECT ROW_NUMBER () OVER ( PARTITION BY OPERATING_TYPE ORDER BY OPERATING_DATE DESC ) rn, PPE_EQUIPMENT_RUN_WATER.* FROM PPE_EQUIPMENT_RUN_WATER ) a WHERE a.rn = 1关键Over()分析函数说明：聚合函数（如sum()、max()等）可以计算基于组的某种聚合值，