oracle数据库相同id去重

来源:互联网 发布:Excel图表突出数据 编辑:程序博客网 时间:2024/05/21 04:19

用distinct,查看表结构,tags为clob类型,需要转换

select  distinct a.id AS "id",a.del_flag AS "delFlag",to_char(a.tags) AS "tags" from mda_subsidies a