SELECT DATEADD(month, DATEDIFF(month, 0, t.Date1), 0) AS Date1 , MAX(degree) AS MaxDegree FROM table1 t WHERE YEAR(t.Date1) IN (2014) GROUP BY DATEADD(month, DATEDIFF(month, 0, t.Date1), 0)
select max(degree), Format(date1, "mmm") from table1 group by Format(date1, "mmm")
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)