Skip to content

Instantly share code, notes, and snippets.

@simonthompson99
Last active January 15, 2021 11:41
Show Gist options
  • Select an option

  • Save simonthompson99/bf87afee3a3dbe6f9a4adcf66b0e75b9 to your computer and use it in GitHub Desktop.

Select an option

Save simonthompson99/bf87afee3a3dbe6f9a4adcf66b0e75b9 to your computer and use it in GitHub Desktop.
[Include table of values in query] Specify table of values in query #sql #database
SELECT * FROM (VALUES (1, 'one'), (2, 'two'), (3, 'three')) AS t (num,letter);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment