select * from sdm_server_dev.sdm_attribute a
where exists (select attr_name from sdm_server_dev.sdm_attribute where entity_id=a.entity_id and attr_name=a.attr_name group by attr_name having count(*)>1);
SQL中,根据某列条件,查询另外一列中的重复值
于 2020-04-26 14:50:28 首次发布