获取表中每个类型最新一条记录【Postgresql】

每条数据的编号：row_number()
分组排序：over(partition by 分组的字段 order by 排序的字段)
num＝1：对分组后的数据获取第一条，也就是最新一条

SELECT * FROM (SELECT ROW_NUMBER() over(PARTITION BY code ORDER BY create_time DESC ) AS num, * FROM t_goods) aa WHERE 1 = 1
AND aa.num = 1 ORDER BY aa.create_time DESC;