SELECT col1, MAX(CONCAT(col3,col2)) from tabella
group by col1