admin管理员组

文章数量:1641805

对于同一张表进行group by 即可 ,注意第一次排序需要group by Id 和真正需要分组的字段,然后进行排序,最后再进行group by 一次就行了

SELECT id, settle_tax_mny,total_settle_tax_mny,contract_id,contract_name,max(create_time) from (SELECT id, settle_tax_mny,total_settle_tax_mny,contract_id,contract_name,create_time FROM table where dr = 0 GROUP BY id,contract_id ORDER BY create_time desc) t where 1=1 GROUP BY t.contract_id

本文标签: 字段每组数据groupmysql