MySQL Query Help

How do i select the latest id on the one that are multiples from a query? The ones that have the same values for binNo I just want the latest.

Select id, binNo, cwts
From  roughstoragesum t1
where id = (select max(id) from roughstoragesum where t1.binNo =roughstoragesum.binNo)
order by id desc
1 Like