clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1716886 fiddles created (23865 in the last week).

create table matable ( madate date, section character(50) );
 hidden batch(es)


insert all into matable (section, madate) values ('500', to_date('08/12/2018','DD/MM/YYYY')) into matable (section, madate) values ('500',to_date('12/09/2020','DD/MM/YYYY')) into matable (section, madate) values ('400',to_date('25/04/2015','DD/MM/YYYY')) into matable (section, madate) values ('400',to_date('26/07/2019','DD/MM/YYYY')) into matable (section, madate) values ('300',to_date('10/10/2020','DD/MM/YYYY')) into matable (section, madate) values ('300',to_date('02/12/2018','DD/MM/YYYY')) select 1 from dual;
6 rows affected
 hidden batch(es)


select section, max(madate) as madate from matable group by section;
SECTION MADATE
500 12-SEP-20
400 26-JUL-19
300 10-OCT-20
 hidden batch(es)