根据用户编码分组。根据日期倒序排序只取其中一条

 select * from ( select *  from (SELECT c.*,row_number() over(PARTITION BY c.reg_channels ORDER BY c.CREATE_TIME DESC) rn  FROM app_user c ) where rn=1  )jj  where jj.reg_channels='SAPP002'