SELECT id, order_id, max(amount) as amount FROM `nome_tabella` group by order_id order by id asc Ciao!
Regole del Forum