用row_number()over(partition by col1 order by col2)--此方法
例如:SELECT * FROM (SELECT a.*,ROW_NUMBER () OVER (PARTITION BY title ORDER BY fodderCode DESC) rn FROM tcsfodder a) WHERE rn <= 1; 这样就可以了,把title替换成你想要的分组,把fodderCode替换成你想要的排序字段
select * from table_name where f1||f2 in (select f1||max(f2) from table_name group by f1 )
FROM (SELECT a.*,ROW_NUMBER () OVER (PARTITION BY title ORDER BY fodderCode DESC)
rn
FROM tcsfodder a)
WHERE rn <= 1; 这样就可以了,把title替换成你想要的分组,把fodderCode替换成你想要的排序字段
where f1||f2 in
(select f1||max(f2) from table_name
group by f1
)