17,088
社区成员
发帖
与我相关
我的任务
分享
select * from (
select t.*,
row_number() over( partition by t.panel_id, t.eqp_id, t.ppid, t.main_grade, t.glass_grade, t.defect_code_1, t.defect_position_1, t.action_user order by t.time_stamp desc)as rn
from cmv_h_wip_sdef t where t.panel_id='D97005024K75'
) where rn=1
;