group by 取每组最新的一条
单表操作select mac(a),b,max(time) from test desc group by b;多表关联group by 取每组最新一条select max(a.b_id),max(a.title), max(t.name), max(t.price) from a inner join (select * from b order by id, price...