Skip to content

Instantly share code, notes, and snippets.

@simonthompson99

simonthompson99/include-table-of-values-in-query.sql

Last active January 15, 2021 11:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save simonthompson99/bf87afee3a3dbe6f9a4adcf66b0e75b9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save simonthompson99/bf87afee3a3dbe6f9a4adcf66b0e75b9 to your computer and use it in GitHub Desktop.
Download ZIP
[Include table of values in query] Specify table of values in query #sql #database
Raw
include-table-of-values-in-query.sql
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