How do I find duplicate values in a table in Oracle?

by

Aggregate the column by COUNT, then use a HAVING clause to find values that appear greater than one time.

SELECT column_name, COUNT(column_name)
FROM table_name
GROUP BY column_name
HAVING COUNT(column_name) > 1;

More Related Contents:

  1. The most efficient way to UPPER CASE two columns in a single query [closed]
  2. Current date in Oracle Db
  3. Merging two tables in SQL [closed]
  4. I want to search job and salary from employee table but I am getting error like invalid relational operator [closed]
  5. How do I do top 1 in Oracle? [duplicate]
  6. Case insensitive searching in Oracle
  7. Get value based on max of a different column grouped by another column [duplicate]
  8. Multiplication aggregate operator in SQL
  9. Pivoting rows into columns dynamically in Oracle
  10. MySQL equivalent of DECODE function in Oracle
  11. How do I select all the columns from a table, plus additional columns like ROWNUM?
  12. SQL error “ORA-01722: invalid number”
  13. Disable all table constraints in Oracle
  14. Get month name from date in Oracle
  15. ORA – 00933 confusion with inner join and “as”
  16. SQL Error: ORA-00942 table or view does not exist
  17. How to count the number of occurrences of a character in an Oracle varchar value?
  18. Comparing with date in Oracle sql
  19. Is it possible to query a comma separated column for a specific value?
  20. SQL selecting rows by most recent date with two unique columns
  21. How to extract group from regular expression in Oracle?
  22. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  23. How to extract week number in sql
  24. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  25. How to handle optional parameters in SQL query?
  26. Return number from Oracle Select statement after parsing date
  27. How do you interpret a query’s explain plan?
  28. How to call Oracle MD5 hash function?
  29. SQL Server equivalent of WM_CONCAT function [duplicate]
  30. Oracle: ‘= ANY()’ vs. ‘IN ()’

Leave a Comment