SQLize Online / PHPize Online  /  SQLtest Online

create table test( date date, `index` int ); insert into test values('2018-12-11', 1); insert into test values('2019-12-12', 1); insert into test values('2018-11-12', 3); insert into test values('2020-12-13', 10); insert into test values('2020-09-13', 54); insert into test values('2021-10-13', 32); insert into test values('2021-11-13', 12); select (select `index` from test where year(date) = '2018' order by date desc limit 1 ) as '2018', (select `index` from test where year(date) = '2019' order by date desc limit 1 ) as '2019', (select `index` from test where year(date) = '2020' order by date desc limit 1 ) as '2020', (select `index` from test where year(date) = '2021' order by date desc limit 1 ) as '2021' ;