SELECT * FROM (SELECT ROW_NUMBER() OVER(PARTITION BY t.vc_customname ORDER BY vc_replydate DESC) rn,
t.*
FROM T_OMS_confirmation t where t.vc_customname like '%2%'
) a where a.rn=1
这里先查询表T_OMS_confirmation ,vc_customname作为查询条件;根据vc_customname分组,根据vc_replydate的最大值