Skip to content

Instantly share code, notes, and snippets.

@ssinfod
Created April 9, 2018 17:05
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 ssinfod/e59ed417fe3bc870ac0f6f13e00b8c02 to your computer and use it in GitHub Desktop.
Save ssinfod/e59ed417fe3bc870ac0f6f13e00b8c02 to your computer and use it in GitHub Desktop.
Question sql.
GOOD: The following is OK because ID is not used twice in the same SITE
ID SITE
A 1
B 1
C 1
A 2
B 2
C 2
BAD: This is bad because ID B is used twice in the same SITE.
ID SITE
A 1
B 1
B 1
A 2
B 2
C 2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment