Skip to content

Instantly share code, notes, and snippets.

@edersqo

edersqo/dcsPriceDiff.sql

Created April 11, 2018 12:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save edersqo/7377d40447c33f6c7bf07c867c77d546 to your computer and use it in GitHub Desktop.
Save edersqo/7377d40447c33f6c7bf07c867c77d546 to your computer and use it in GitHub Desktop.
Download ZIP
Count differences between DCS_PRICE in CATA, and CATB
Raw
dcsPriceDiff.sql
-- Count differences between DCS_PRICE in CATA, and CATB
SELECT COUNT(*)
FROM
(
SELECT * FROM WLM_PROD_CATA.DCS_PRICE
MINUS
SELECT * FROM WLM_PROD_CATB.DCS_PRICE
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment