下面的SQL语句dr.DATACONTENT是CLOB类型,当我加上distinct就报错,我一搜发现是CLOB类型的不能用distinct,可是如果我不加又有重复了,我应该怎么解决呢?
select
distinct dr.dataid, dr.DATACONTENT,dr.dataname,
dr.DATAURL,
dr.DATADESC,
dr.ISDOWNLOAD,
dr.FENSTATE,
dr.FENUSERID,
dr.fenreason,
dr.HASINDEXMETADATA,
drr.dataid
from tb_datarecord dr, tb_datarole_relation drr
where dr.dataid = drr.dataid(+)
and dr.dataid in (select distinct drrt.dataid from tb_datarole_relation drrt)
select
distinct dr.dataid, dr.DATACONTENT,dr.dataname,
dr.DATAURL,
dr.DATADESC,
dr.ISDOWNLOAD,
dr.FENSTATE,
dr.FENUSERID,
dr.fenreason,
dr.HASINDEXMETADATA,
drr.dataid
from tb_datarecord dr, tb_datarole_relation drr
where dr.dataid = drr.dataid(+)
and dr.dataid in (select distinct drrt.dataid from tb_datarole_relation drrt)
疑问:还有对clob字段的distinct