MAX() + GROUP BY

Fetch the row which has the Max value for a column on Mysql

Posted on June 19, 2013 by Shiji Pan

I have a MySQL table clientipstat, 3 columns: barcode, statdate, count. I want to get the latest row for each barcode(1 result per unique barcode), like ... Read more

Withdata Software

Producing high-quality database tools

Tag Archives: MAX() + GROUP BY

Fetch the row which has the Max value for a column on Mysql