Skip to content

Instantly share code, notes, and snippets.

@gsampath127

gsampath127/unique_comb_1.sql

Last active October 11, 2019 20:52
Show Gist options
  • Save gsampath127/e91a0ac7dc6e7bc54e0bd4e2bbaf8c4d to your computer and use it in GitHub Desktop.
Save gsampath127/e91a0ac7dc6e7bc54e0bd4e2bbaf8c4d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
unique_comb_1.sql
SELECT * INTO #Team FROM
(
SELECT 1 AS ID,'India' Team
UNION ALL
SELECT 2 AS ID,'England' Team
UNION ALL
SELECT 3 AS ID,'Australia' Team
UNION ALL
SELECT 4 AS ID,'Newzeland' Team
UNION ALL
SELECT 5 AS ID,'Srilanka' Team
)p
SELECT * FROM #Team
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment