Mysql Group By 获取每组最大一条

• 单表查询

SELECT * FROM fof_nav WHERE (fof_id,date) IN (SELECT fof_id,max(date) FROM fof_nav GROUP BY fof_id)

• 如果需要联其他表

SELECT fof.*, fof_nav.date, fof_nav.nav FROM fof INNER JOIN fof_nav ON fof.id = fof_id WHERE (fof_id,date) IN (SELECT fof_id,max(date) FROM fof_nav GROUP BY fof_id)