SQL how to compare two tables for same data content?

by

You should be able to “MINUS” or “EXCEPT” depending on the flavor of SQL used by your DBMS. 

select * from tableA
minus
select * from tableB

If the query returns no rows then the data is exactly the same.

More Related Contents:

  1. Is there any rule of thumb to construct SQL query from a human-readable description?
  2. How can I list the tables in a SQLite database file that was opened with ATTACH?
  3. In MySQL queries, why use join instead of where?
  4. Doing a WHERE .. IN subquery in Doctrine 2
  5. Transpose latest rows per user to columns
  6. Is there any boolean type in Oracle databases?
  7. Physical vs. logical (hard vs. soft) delete of database record? [closed]
  8. SQLite – ORDER BY RAND()
  9. The Next-gen Databases [closed]
  10. Splitting the string in sql server
  11. Need to list all triggers in SQL Server database with table name and table’s schema
  12. What is the purpose of constraint naming
  13. How can I do a BEFORE UPDATED trigger with sql server?
  14. Drop all tables command
  15. How to find a table having a specific column in postgresql
  16. Deferrable Constraints in SQL Server
  17. can we list all tables in msaccess database using sql?
  18. INSERT COMMAND :: ERROR: column “value” does not exist
  19. Comma separated values in a database field
  20. Can SQL Server Express LocalDB be connected to remotely?
  21. What can cause an Oracle ROWID to change?
  22. SQL: Using NULL values vs. default values
  23. Why don’t DBMS’s support ASSERTION
  24. How do I change db schema to dbo
  25. PostgreSQL how to create a copy of a database or schema?
  26. Query a Table’s Foreign Key relationships
  27. Historical / auditable database
  28. Postgres: convert single row to multiple rows (unpivot)
  29. How to store a list in a db column
  30. Copy table structure to new table in sqlite3

Leave a Comment