codice:
SELECT col1, Max(col2) AS MaxDicol2
FROM Tabella
GROUP BY col1;