row_number() over(partition by c_vip_id order by creationDate ) 然后取结果为1的就可以了
select c_vip_id,hr_id,c_store_id,creationdate,... from ( select c_vip_id,hr_id,c_store_id,creationdate,...,row_number() over(partition by c_vip_id order by creationDate ) rn from tab_name ) where rn=1;
(
select c_vip_id,hr_id,c_store_id,creationdate,...,row_number() over(partition by c_vip_id order by creationDate ) rn from tab_name
)
where rn=1;