Re: create function help

[Rick James]

This might get the same value:

SELECT acc, yearmon AS ym, matd, disc
    FROM ( SELECT *
              FROM longacc_hist
              ORDER BY yearmon DESC
         )
    GROUP BY acc;

It uses the 'feature' that GROUP BY will take the first row from each group; the "ORDER BY yearmon DESC" arranges for the first row to have the MAX and the disc you are looking for.