I have a table with column Id,Name,Version Column Id contains duplicate and I only need to select one of each Id, but only the one with the highest version number.
I tried this, but it does not work:
select *
from table1
group by Id,version
Can someone drive me on the right direction?
Thanks,
