Posts by user237319 • 1 point

• -1

  votes

  2

  answers

  125

  views

  A: Mysql load the last purchase of each item

  use a sub query select * from compra inner join (select max(id)as id,item from compra group by item) as _last on compra.id=_last.id

  mysql

  answered 3 years, 1 month ago user237319 1