Sql

(
  SELECT * FROM table1
  EXCEPT DISTINCT
  SELECT * from table2
)

UNION ALL

(
  SELECT * FROM table2
  EXCEPT DISTINCT
  SELECT * from table1
)

PREVIOUS	NEXT

Code Example
Sql :: find the all the constraints in a specific table
Sql :: set engine to innodb
Sql :: sql use with to get value counts and percentages
Sql :: generate series sybase
Sql :: unique sql
Sql :: how to check which table has data in mysql
Sql :: alter session set nls_language french
Sql :: postgresql find missing id
Sql :: how to check common records in 2 table
Sql :: Write a PL/SQL to print even numbers upto 100.
Sql :: retrieve all data from a one row in mysql
Sql :: many to many flask-sqlalchemy
Sql :: show sql property syntax for jpa.
Sql :: sqlalchemy query sql compiled
Sql :: sql not in operator
Sql :: export database with data sql server
Sql :: plsql find location of procedure
Sql :: 0
Sql :: sql join on wildcard
Sql :: get month from date sql server
Sql :: import Data in MySQL without using any other software
Sql :: how to convert null to float in mysql
Sql :: show broken table mysql
Sql :: timestamp(0) postgresql
Sql :: mysql trim characters
Sql :: find max number in sql
Sql :: sql not operator
Sql :: how to find 2nd highest salary in mysql
Sql :: right join
Sql :: postgresql multiple insert with subquery