什么是最简单的SQL语句,它将返回给定列的重复值及其在Oracle数据库表中的出现次数?
例如:我有一个JOBS
包含列的表JOB_NUMBER
。我怎样才能知道我是否有任何副本JOB_NUMBER
,以及它们被复制了多少次?
发布于 2018-08-01 08:39:42
SELECT <column>, count(*)
FROM <table>
GROUP BY <column> HAVING COUNT(*) > 1;
SELECT job_number, count(*)
FROM jobs
GROUP BY job_number HAVING COUNT(*) > 1;
发布于 2018-08-01 08:55:30
select column_name, count(column_name)
from table
group by column_name
having count (column_name) > 1;
https://stackoverflow.com/questions/-100000469
复制相似问题