cyberfly
1/3/2019 - 4:21 AM
Mysql group by get latest row
Normal group by will show the first result. To get the last result for group by, use max()
select max(id) from company_relocation_histories group by company_idNormal group by will show the first result. To get the last result for group by, use max()
select max(id) from company_relocation_histories group by company_id