select * from (
select a.*,row_number() over(partition by grower_pk order by a.pk_id desc) as rn from T_IN a
--先按grower_pk进行排序,把所有相同的grower_pk排在一起在排序,虽然我order by pk_id 也没有效果,再给每条grower_pk相同数据进行编号从1开始。
) as oo where oo.rn=1
-- rn=1 就是获取排序后的第一条
select * from (
select a.*,row_number() over(partition by grower_pk order by a.pk_id desc) as rn from T_IN a
--先按grower_pk进行排序,把所有相同的grower_pk排在一起在排序,虽然我order by pk_id 也没有效果,再给每条grower_pk相同数据进行编号从1开始。
) as oo where oo.rn=1
-- rn=1 就是获取排序后的第一条