Removing duplicate rows from table in Oracle

by

Use the rowid pseudocolumn.

DELETE FROM your_table
WHERE rowid not in
(SELECT MIN(rowid)
FROM your_table
GROUP BY column1, column2, column3);

Where column1, column2, and column3 make up the identifying key for each record. You might list all your columns.

More Related Contents:

  1. Delete duplicate records in SQL Server?
  2. The most efficient way to UPPER CASE two columns in a single query [closed]
  3. ORA-01843 Not a valid month
  4. Merging two tables in SQL [closed]
  5. I want to search job and salary from employee table but I am getting error like invalid relational operator [closed]
  6. How to delete duplicate rows in SQL Server?
  7. Inner join vs Where
  8. Oracle SELECT TOP 10 records [duplicate]
  9. Oracle’s default DATE format
  10. How can you tell if a value is not numeric in Oracle?
  11. Select a random sample of results from a query result
  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. SQL selecting rows by most recent date with two unique columns
  20. How to extract group from regular expression in Oracle?
  21. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  22. How to extract week number in sql
  23. How to use Timestamp_to_scn and Scn_to_timestamp in Oracle?
  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. What does a (+) sign mean in an Oracle SQL WHERE clause? [duplicate]
  27. Connecting to Oracle Database using Sql Server Integration Services
  28. How to bulk insert only new rows in PostreSQL
  29. ORA-00933: SQL command not properly ended
  30. Update a table with data from another table

Leave a Comment