sql 去重 （distinct）

select distinct a.ACT_ID,a.IS_REQUIRED,a.TYPE,a.SCOPE,a.CRE_TIME,a.CRE_USER,a.BEGIN_TIME,a.END_TIME,a.ACT_CASE_ID,a.SCORE,a.STUDIO_ID   from SD_STUDIO_ACT_USER u,SD_STUDIO_ACT a where 1=1 and u.ACT_CASE_ID=a.ACT_CASE_ID and a.DELETE_FLAG=0 /~ and a.STUDIO_ID={studioId} ~/  /~ and u.FANS_TYPE={joinType} ~/  /~ and a.CRE_USER={userId}~/  /~ and a.Type={actType} ~/  /~ and a.BEGIN_TIME > {nobeginTime} ~/ /~ and a.END_TIME < {hasEndTime} ~/  /~ and a.BEGIN_TIME < {nowTime} ~/ /~ and a.END_TIME > {now1Time} ~/ order by a.begin_time desc