Q&A for people studying math at any level and professionals in related fields
Select ID,Title,PostTypeID,Score,Max(Score)as MaxScoreByType From Posts Group by PostTypeId,ID,Title,Score