title: Selecting the distinct values from three columns with the max of a fourth where there are duplicates
body: <p>I have a table with one numeric value (n) and three string values (a,b,c). How do I query this table so that I get only distinct values of (a,b,c) and if there are duplicates, take the maximum of the corresponding set of n values?</p>