SELECT *
FROM (SELECT s.*,
ROW_NUMBER() OVER ( PARTITION BY id, name, age ORDER BY create_time DESC ) AS row_num
FROM user_info s
WHERE name= #{name}
AND age = #{age}
) tmp
WHERE tmp.row_num = 1
查询最新数据
于 2024-07-17 10:27:36 首次发布