Re: selecting distinct records with group max value

[Peter Brawley]

Wouldn't that just be...

DROP TEMPORARY TABLE IF EXISTS tmp;
SET @prev = -1;
CREATE TEMPORARY TABLE tmp
SELECT
fld1, fld2, fld3, val,
IF( fld1 = @prev, 0, @prev := fld1 ) AS Sel
FROM tbl
ORDER BY fld1 ASC, val DESC;

SELECT fld1, fld2, fld3, val FROM tmp WHERE sel > 0;

DROP TEMPORARY TABLE tmp;

PB