2808 explained code solutions for 75 technologies


clickhouseUsing argMax() function


SELECT argMax(date, age) FROM tblctrl + c
argMax

returns value of the first argument for the max value of the second argument

tbl

table to select data from

date, age

will return date column value for a row with maximum age column value