Selecting the distinct values from three columns with the max of a fourth where there are duplicates

select max(n), a, b, c
from mytable
group by a, b, c

select a, b, c, max(n)
from table
group by a, b, c;