用Oracle rank partition 筛选记录

例子:

 

select * from

(

select kid,id,val2, rank() over (partition by kid order by id) rank from table1

) where rank = 1;

 

 

按照kid分组，选取含有最小的id的记录集