请教各位大神oracle语句select如何排除重覆资料

select C70.CCES070_NAME 姓名, c70.CCES070_CONTTEL 连络电话,mbb.e_mail 邮件,mbb.address 地址       ,CCES062_NAME 课程名称, c992.cces099_desc 课程类型,trim(FD.FDEPT_NAME) 上课分店,TO_CHAR(CCES081_CLASSDATE,'YYYYMMDD') 上课日期 from CCES070 C70join CCES062 C62 ON (C62.CCES062_CLASSID = C70.CCES070_CLASSID)join CCES081 C81 ON (C81.CCES081_CLASSID = C62.CCES062_CLASSID)--JOIN CCES099 C99  ON (CCES062_ZONE = C99.cces099_2nd ) and C99.cces099_1st='N'  --关联上课星期--JOIN CCES099 C991 ON (CCES062_ZONE = c991.cces099_2nd ) and c991.cces099_1st='M'  --关联上课时段join CCES099 c992 ON (CCES062_TYPE = c992.cces099_2nd ) and c992.cces099_1st='I'  --关联上课类型JOIN CCES090 C90   ON (c90.cces090_staffid=c62.CCES062_TEACHER) --关联老师JOIN FDEPT_view FD ON (trim(fd.fdept_code) = C62.CCES062_AREA)JOIN cheer.MemberCard MC ON mc.mem_cardno  =  C70.CCES070_MBCARD    --关联学生的卡号JOIN cheer.MEMBERSHIP MBb ON (MBb.MEMBER_CODE = mc.member_code) --关联学生的会员编号JOIN CHEER.shop sp ON (sp.shop_code = mbb.shop_code)  where TO_CHAR(cces081_classdate,'YYYYMMDD')  >= '20220101' AND TO_CHAR(cces081_classdate,'YYYYMMDD') <= '20221231'AND C70.CCES070_STATUS = 'Y' --上课状态 Y 确定参加--and cces070_classid='V000320201127011'--group by C70.CCES070_NAMEorder by cces081_classdate