Oracle SQL get row with MAX value for each group in a set of grouped results

sql select row with max date group by
select max record for each group oracle
sql max group by multiple columns
select all columns but group by one column in oracle
group by and find max in sql
sql server select row with max value
oracle sql total count group by
postgres select row with max value