QUALIFY

SELECT
id_ver
,nm_ver
,dttm_ver_upd
FROM
VUGD_VER_INFO
GROUP BY
id_ver
,nm_ver
,dttm_ver_upd
QUALIFY row_number() over(order by dttm_ver_upd DESC) = '1'

Tweet