SELECT Name , MAX(Quali1) AS Quali1 , MAX(year1) AS year1 , MAX(Quali2) AS Quali2 , MAX(Quli2) AS Quli2 FROM x GROUP BY Name
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)