mysql 批量查询取每一组最新一条数据

目录

• AI回答 
• 需求
• 方式1
• 查询所有数据
• 结论
• 最终查询

SELECT number_plate,id,contract_no, MAX( create_time ) AS latest FROM  
    yl_lease_collect     GROUP BY number_plate ;

SELECT
    m1.id, m1.contract_no
FROM
    yl_lease_collect m1
    JOIN 
    ( 
    SELECT number_plate, MAX( create_time ) AS latest FROM  
    yl_lease_collect where number_plate in(
'123沪123'
    ) 
    GROUP BY number_plate 
    ) m2 
    ON m1.number_plate = m2.number_plate 
    AND m1.create_time = m2.latest
    ;