What column are you wanting to group by? I’ll just call it groupColumn for now, ok? So taking that into account, here is what I’d do:
SELECT groupColumn, max(VersionNumber) FROM tableName GROUP BY groupColumn;
Hope that help!
REGISTER or login:
select * from fpitmmas where (itvndn, itmnum)
in(select itvndn, max(itmnum) from fpitmmas group by itvndn)