laughedelic/diff.sql

Created April 8, 2019 10:41

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/laughedelic/eadd6b0dc7f3a95bfb1aa2fbdd482bcc.js"></script>
Save laughedelic/eadd6b0dc7f3a95bfb1aa2fbdd482bcc to your computer and use it in GitHub Desktop.

Download ZIP

See the difference between two tables on the given column

Raw

	SELECT DISTINCT
	a.column AS a_column,
	b.column AS b_column
	FROM
	a FULL JOIN b
	ON a.column = b.column
	WHERE
	a.column IS NULL OR
	b.column IS NULL

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment