下面直接上示例:
select t.*
from (select row_number() over(partition by tor.order_name order by tor.order_id desc) rn, tor.* from tc_order tor) t
where t.rn = 1;
tc_order
:表名order_name
:分组列名order_id
:排序列名(可以有多个排序)row_number
:分组序号over(partition by tor.order_name order by tor.order_id desc)
:这是oracle的分析函数