9951 explained code solutions for 126 technologies

clickhouseUsing argMax() function

SELECT argMax(date, age) FROM tblctrl + c

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


table to select data from

date, age

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