1. Generate Number table with cross join and row_number function
CREATE TABLE numbers (n INT NOT NULL PRIMARY KEY);GO;WITH L0 AS (SELECT 1 AS col UNION ALL SELECT 1 AS col), L1 AS (SELECT 1 AS col FROM L0 AS A, L0 AS B), --4 L2 AS (SELECT 1 AS col FROM L1 AS A, L1 AS B), --16 L3 AS (SELECT 1 AS col FROM L2 AS A, L2 AS B),--256 L4 AS (SELECT 1 AS col FROM L3 AS A, L3 AS B),--65536 L5 AS (SELECT 1 AS col FROM L4 AS A, L4 AS B),--4294967296 NUM AS (SELECT ROW_NUMBER() OVER(ORDER BY col) AS n FROM L5)INSERT numbers (n) SELECT n FROM NUM WHERE n <= 100000;
In this method, we are squaring the number of records from the previous CTE and generate a new CTE. In this way, we are able to generate a table with 4^32 records. Then we are using the ROW_NUMBER function to generate the numbers and limit the numbers based on the maximum number that we want to generate.
This solution is originally created by Itzik Ben-Gan
-- Number of records in each CTE expression above.SELECT COUNT(1) FROM L0 --2SELECT COUNT(1) FROM L1 --4SELECT COUNT(1) FROM L2 --16SELECT COUNT(1) FROM L3 --256SELECT COUNT(1) FROM L4 --65536SELECT COUNT(1) FROM L5 --4294967296
2. Use generate_series() built-in function
This function is relatively new and it is available in SQL Server 2022 preview version.
-- SQL Server 2022-- generate number from 1 to 100SELECT value FROM GENERATE_SERIES(1, 100);--generate odd numbers from 1 to 99 (i.e., 1, 3, 5, 7 ...99)SELECT value FROM GENERATE_SERIES(1, 99, 2);--generate even numbers from 1 to 100 (i.e., 2, 4, 6, 8 ...100)SELECT value FROM GENERATE_SERIES(2, 100, 2);
I suggest you to read Erland Sommarskogโs article on table of numbers for other interesting solutions.
โI
{"docsConfig":{"theme":"almond","$schema":"https://mintlify.com/docs.json","name":"Rajanand","colors":{"primary":"#F54E00","light":"#F9BD2B","dark":"#F54E00"},"favicon":"https://mintcdn.com/rajanand/jl6WdKP_dLzq_MPC/assets/images/rajanand-orange-icon-mark.svg?fit=max\u0026auto=format\u0026n=jl6WdKP_dLzq_MPC\u0026q=85\u0026s=86a5687b1c72374b4419e248dcec1db6","appearance":{"default":"system","strict":false},"background":{"decoration":"windows"},"navbar":{"links":[{"icon":"phone","href":"https://rajanand.org/contact","label":"Contact"}],"primary":{"type":"button","label":"Newsletter","href":"https://rajanand.substack.com/welcome"}},"footer":{"socials":{"website":"https://rajanand.org","x":"https://x.com/iRajanand","linkedin":"https://www.linkedin.com/in/iRajanand","github":"https://github.com/rajanand"},"links":[{"header":"Home","items":[{"label":"Rajanand","href":"https://rajanand.org/"},{"label":"About","href":"https://rajanand.org/about"},{"label":"Subscribe","href":"https://rajanand.substack.com/welcome"}]},{"header":"Connect","items":[{"label":"Book a Meeting","href":"https://bookings.rajanand.org"},{"label":"Send me a message","href":"https://linkedin.com/in/iRajanand"},{"label":"Contact me","href":"https://rajanand.org/contact"}]}]},"search":{"prompt":"Have a great day! ๐คฉ"},"seo":{"indexing":"navigable"},"fonts":{"heading":{"family":"Merriweather"},"body":{"family":"Space Grotesk"}},"styling":{"eyebrows":"breadcrumbs","codeblocks":"system","latex":true},"integrations":{"gtm":{"tagId":"GTM-T7P3GC"},"cookies":{"key":"website-name","value":"rajanand.org"}},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"rajanand","hasAudioNarration":false,"actualSubdomain":"rajanand","customDomains":["rajanand.org"],"gitSource":{"type":"github","owner":"rajanand","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":false,"mountPath":"","label":""},"feedback":{"thumbs":false},"entitlements":{},"buildId":"6ae923f7416fcb78afb0be3f:success","clientVersion":"0.0.4270","searchFilterCounts":[{"language":"default","tag":"Home","count":9},{"language":"default","tag":"Web","count":9},{"language":"default","tag":"Certifications","count":6},{"language":"default","tag":"Toolbox","count":2}]},"assistantConfig":{},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"site-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"treatment","enabled":true,"payload":{"type":"string","value":"treatment"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":true},"customCss":[{"filePath":"style.css","content":"#navbar-transition-willow{font-family:\"Shantell Sans\", \"Inter\";font-size:16px}"}]}
{"page":{"pagePath":"sql/how-to-generate-numbers-table-in-sql","slug":"/sql/how-to-generate-numbers-table-in-sql","pageMetadata":{"title":"How to generate numbers table in SQL?","sidebarTitle":"Generate Numbers Table","description":null,"icon":"star","iconType":"duotone","mode":"wide","href":"/sql/how-to-generate-numbers-table-in-sql"},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,p:`p`,pre:`pre`,span:`span`,..._provideComponents(),...props.components},{CodeBlock,Heading}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Heading)_missingMdxReference(`Heading`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`2`,id:`1-generate-number-table-with-cross-join-and-row_number-function`,children:`1. Generate Number table with cross join and row_number function`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`14`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`14`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`CREATE`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` TABLE`}),_jsx(_components.span,{style:{color:`#8250DF`,\"--shiki-dark\":`#DCDCAA`},children:` numbers`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` (n `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`INT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` NOT NULL`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` PRIMARY KEY`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`);`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`GO`})}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`WITH`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L0 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` (`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 1`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` col `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`UNION ALL`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SELECT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 1`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` col), `})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L1 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` (`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 1`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` col `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L0 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` A, L0 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` B), `}),_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`--4`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L2 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` (`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 1`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` col `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L1 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` A, L1 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` B), `}),_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`--16`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L3 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` (`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 1`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` col `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L2 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` A, L2 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` B),`}),_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`--256`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L4 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` (`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 1`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` col `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L3 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` A, L3 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` B),`}),_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`--65536`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L5 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` (`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 1`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` col `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L4 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` A, L4 `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` B),`}),_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`--4294967296`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` NUM `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` (`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:` ROW_NUMBER`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`() `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`OVER`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`ORDER BY`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` col) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`AS`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` n `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L5)`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`INSERT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` numbers (n)`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SELECT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` n `})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` NUM `})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` WHERE`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` n `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`\u003c=`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:` 100000`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`]})})}),`\n`,_jsxs(_components.p,{children:[`In this method, we are squaring the number of records from the previous CTE and generate a new CTE. In this way, we are able to generate a table with 4^32 records. Then we are using the ROW_NUMBER function to generate the numbers and limit the numbers based on the maximum number that we want to generate.\nThis solution is originally created by `,_jsx(_components.a,{href:`https://twitter.com/itzikbengan`,children:`Itzik Ben-Gan`})]}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`7`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`7`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-- Number of records in each CTE expression above.`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:` COUNT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`1`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L0 `}),_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`--2`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:` COUNT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`1`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L1 `}),_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`--4`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:` COUNT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`1`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L2 `}),_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`--16`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:` COUNT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`1`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L3 `}),_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`--256`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:` COUNT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`1`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L4 `}),_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`--65536`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:` COUNT`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`1`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`FROM`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` L5 `}),_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`--4294967296`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`2`,id:`2-use-generate_series-built-in-function`,children:`2. Use generate_series() built-in function`}),`\n`,_jsxs(_components.p,{children:[`This function is relatively new and it is available in `,_jsx(_components.a,{href:`https://docs.microsoft.com/en-us/sql/t-sql/functions/generate-series-transact-sql?view=sql-server-ver16`,children:`SQL Server 2022`}),` preview version.`]}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`11`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`11`,children:[_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-- SQL Server 2022`})}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-- generate number from 1 to 100`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` value`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` FROM`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:` GENERATE_SERIES`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`1`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`100`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`);`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`--generate odd numbers from 1 to 99 (i.e., 1, 3, 5, 7 ...99)`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` value`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` FROM`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:` GENERATE_SERIES`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`1`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`99`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`2`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`);`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`--generate even numbers from 1 to 100 (i.e., 2, 4, 6, 8 ...100)`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`SELECT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` value`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` FROM`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#DCDCAA`},children:` GENERATE_SERIES`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`(`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`2`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`100`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`, `}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`2`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`);`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`]})})}),`\n`,_jsxs(_components.p,{children:[`I suggest you to read `,_jsx(_components.a,{href:`https://www.sommarskog.se/Short%20Stories/table-of-numbers.html`,children:`Erland Sommarskogโs`}),` article on table of numbers for other interesting solutions.`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"codeStyling":"system","config":{},"pageMetadata":{"title":"How to generate numbers table in SQL?","sidebarTitle":"Generate Numbers Table","description":null,"icon":"star","iconType":"duotone","mode":"wide","href":"/sql/how-to-generate-numbers-table-in-sql"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"1. Generate Number table with cross join and row_number function","slug":"1-generate-number-table-with-cross-join-and-row_number-function","depth":2,"children":[]},{"title":"2. Use generate_series() built-in function","slug":"2-use-generate_series-built-in-function","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"rajanand","siteName":"Rajanand","title":"How to generate numbers table in SQL? - Rajanand","navMaps":{"firstHrefInVersion":{"๐ป Tech":{"href":"/sql/how-to-generate-numbers-table-in-sql","matchLevel":0},"๐ Growth":{"href":"/book-summary/atomic-habits","matchLevel":4}},"firstHrefInLanguage":{}},"lastModified":"2026-07-06T06:50:55.006Z","originalFileLocation":"sql/how-to-generate-numbers-table-in-sql.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"application-name\" content=\"Rajanand\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/rajanand/2C8Q5VH8V_xRuC-n/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/rajanand/2C8Q5VH8V_xRuC-n/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/rajanand/2C8Q5VH8V_xRuC-n/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/rajanand/2C8Q5VH8V_xRuC-n/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/rajanand/2C8Q5VH8V_xRuC-n/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/rajanand/2C8Q5VH8V_xRuC-n/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/rajanand/2C8Q5VH8V_xRuC-n/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/rajanand/2C8Q5VH8V_xRuC-n/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/rajanand/2C8Q5VH8V_xRuC-n/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"How to generate numbers table in SQL? - Rajanand\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Rajanand\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://rajanand.org/sql/how-to-generate-numbers-table-in-sql\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://rajanand.mintlify.site/_mintlify/api/og/v2?division=Documentation\u0026amp;title=How+to+generate+numbers+table+in+SQL%3F\u0026amp;theme=4e5d867d333f71c88c779285\u0026amp;signature=e4f66beb0d2caae28e1c6579bc248f05ec41d0f02b055f19ff2e0a04d158ab38\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"How to generate numbers table in SQL? - Rajanand\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://rajanand.mintlify.site/_mintlify/api/og/v2?division=Documentation\u0026amp;title=How+to+generate+numbers+table+in+SQL%3F\u0026amp;theme=4e5d867d333f71c88c779285\u0026amp;signature=e4f66beb0d2caae28e1c6579bc248f05ec41d0f02b055f19ff2e0a04d158ab38\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/rajanand/2C8Q5VH8V_xRuC-n/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Rajanand\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#F54E00\">\u003clink data-mint-head rel=\"canonical\" href=\"https://rajanand.org/sql/how-to-generate-numbers-table-in-sql\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/sql/how-to-generate-numbers-table-in-sql.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Rajanand\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Rajanand\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/sql/how-to-generate-numbers-table-in-sql.md","siteName":"Rajanand","nav":{"global":null,"versions":[{"version":"๐ป Tech","tabs":[{"tab":"Home","icon":"house","groups":[{"group":"Web","pages":[{"title":"Welcome!","sidebarTitle":"Home","icon":"house","iconType":"duotone","mode":"custom","href":""},{"title":"About me","sidebarTitle":"About","icon":"address-card","iconType":"duotone","mode":"custom","href":"/about"},{"group":"Certifications","icon":"award","pages":[{"title":"Certifications","sidebarTitle":"Overview","icon":"seal","iconType":"duotone","mode":"wide","href":"/certifications/index"},{"title":"Microsoft Certifications","sidebarTitle":"Microsoft","icon":"Microsoft","iconType":"regular","mode":"wide","href":"/certifications/microsoft"},{"title":"Databricks Certification","sidebarTitle":"Databricks","icon":"block-brick","iconType":"duotone","mode":"wide","href":"/certifications/databricks"},{"title":"Snowflake Certification","sidebarTitle":"Snowflake","icon":"snowflake","iconType":"regular","mode":"wide","tag":"NEW","href":"/certifications/snowflake"},{"title":"Tableau Certification","sidebarTitle":"Tableau","icon":"image","iconType":"regular","mode":"wide","href":"/certifications/tableau"},{"title":"Oracle Certification","sidebarTitle":"Oracle","icon":"opera","iconType":"regular","mode":"wide","href":"/certifications/oracle"}]},{"title":"Contact Me","sidebarTitle":"Contact","icon":"Envelope","iconType":"regular","mode":"wide","href":"/contact"}]}]},{"tab":"Toolbox","icon":"toolbox","groups":[{"group":"Toolbox","pages":[{"title":"Tools and Utilities","sidebarTitle":"Overview","icon":"toolbox","iconType":"duotone","mode":"wide","href":"/tools"}]}]},{"tab":"Learning","icon":"book-atlas","hidden":true,"groups":[{"group":"Trainings Completed","icon":"book-atlas","pages":[{"title":"Learning","sidebarTitle":"Overview","icon":"book-open","iconType":"duotone","mode":"wide","href":"/learning/index"},{"title":"AWS Training","sidebarTitle":"AWS","icon":"aws","iconType":"duotone","mode":"wide","href":"/learning/aws"},{"title":"ClickHouse Training","sidebarTitle":"ClickHouse","icon":"barcode","iconType":"duotone","mode":"wide","href":"/learning/clickhouse"},{"title":"IBM Skillbuild","sidebarTitle":"IBM","icon":"bee","iconType":"duotone","mode":"wide","href":"/learning/ibm"}]}]},{"tab":"Data","icon":"server","hidden":true,"groups":[{"group":"Data","pages":[{"title":"Types of Data: Structured, Semi-Structured, and Unstructured Data","sidebarTitle":"Types of Data","icon":"table-list","iconType":"duotone","mode":"nowide","href":"/data/types-of-data"},{"title":"Insert in Delta Table","sidebarTitle":"Insert in Delta Table","icon":"arrow-right-to-bracket","iconType":"duotone","mode":"wide","href":"/data/delta-table-insert"},{"title":"Update in Delta Table","sidebarTitle":"Update in Delta Table","icon":"file-pen","iconType":"duotone","mode":"wide","href":"/data/delta-table-update"},{"title":"Delete in Delta Table","sidebarTitle":"Delete in Delta Table","icon":"trash","iconType":"duotone","mode":"wide","href":"/data/delta-table-delete"}]}]},{"tab":"Data Modeling","icon":"diagram-project","hidden":true,"groups":[{"group":"Data Modeling","pages":[{"title":"Conceptual Data Model","sidebarTitle":"Conceptual Data Model","icon":"briefcase","iconType":"duotone","mode":"wide","href":"/data-modeling/conceptual-data-model"},{"title":"Logical Data Model","sidebarTitle":"Logical Data Model","icon":"network-wired","iconType":"duotone","mode":"","href":"/data-modeling/logical-data-model"},{"title":"Physical Data Model","sidebarTitle":"Physical Data Model","icon":"table-layout","iconType":"duotone","mode":"","href":"/data-modeling/physical-data-model"},{"title":"Dimension Table","sidebarTitle":"Dimension Table","icon":"brightness-low","iconType":"duotone","mode":"wide","href":"/data-modeling/dimension-table"},{"title":"Fact Table","sidebarTitle":"Fact Table","icon":"gauge-high","iconType":"duotone","mode":"","href":"/data-modeling/fact-table"},{"title":"Star Schema","sidebarTitle":"Star Schema","icon":"star","iconType":"duotone","mode":"nowide","href":"/data-modeling/star-schema"},{"title":"Snowflake Schema","sidebarTitle":"Snowflake Schema","icon":"snowflake","iconType":"duotone","mode":"nowide","href":"/data-modeling/snowflake-schema"},{"title":"Inmon Data Model","sidebarTitle":"Inmon Data Model","icon":"down-from-line","iconType":"duotone","mode":"","href":"/data-modeling/inmon-data-model"},{"title":"Kimball Data Model","sidebarTitle":"Kimball Data Model","icon":"up-from-line","iconType":"duotone","mode":"","href":"/data-modeling/kimball-data-model"}]}]},{"tab":"Databricks","icon":"databricks","hidden":true,"menu":[{"item":"Spark Programming","groups":[{"group":"Spark Programming with Databricks","pages":[{"title":"Working in the Databricks Workspace","sidebarTitle":"Databricks Workspace","icon":"cube","iconType":"duotone","mode":"","href":"/databricks/databricks-workspace"},{"title":"Apache Spark Core","sidebarTitle":"Apache Spark Core","icon":"cube","iconType":"duotone","mode":"","href":"/databricks/spark-core"},{"title":"Delta Lake","sidebarTitle":"Delta Lake","icon":"cube","iconType":"duotone","mode":"","href":"/databricks/delta-lake"}]}]},{"item":"Data Engineer Associate","groups":[{"group":"Data Engineer Associate","pages":[{"title":"Databricks Lakehouse Platform","sidebarTitle":"Databricks Lakehouse Platform","icon":"circle-check","iconType":"duotone","mode":"","href":"/databricks/ade-databricks-lakehouse-platform"},{"title":"ELT with Apache Spark","sidebarTitle":"ELT with Apache Spark","icon":"circle-check","iconType":"duotone","mode":"","href":"/databricks/ade-elt-with-apache-spark"},{"title":"Incremental Data Processing","sidebarTitle":"Incremental Data Processing","icon":"circle-check","iconType":"duotone","mode":"","href":"/databricks/ade-incremental-data-processing"},{"title":"Production Pipelines","sidebarTitle":"Production Pipelines","icon":"circle-check","iconType":"duotone","mode":"","href":"/databricks/ade-production-pipelines"},{"title":"Data Governance","sidebarTitle":"Data Governance","icon":"circle-check","iconType":"duotone","mode":"","href":"/databricks/ade-data-governance"}]}]}]},{"tab":"Fabric","icon":"microsoft","hidden":true,"groups":[{"group":"Fabric","pages":[{"title":"Fabric Security: All you need to know","sidebarTitle":"Fabric Security","icon":"shield","iconType":"duotone","mode":"wide","href":"/fabric/fabric-security-all-you-need-to-know"}]}]},{"tab":"Spark","icon":"sparkle","hidden":true,"menu":[{"item":"Overview","icon":"book-open","pages":[{"title":"Spark: Overview","sidebarTitle":"Overview","icon":"star","iconType":"regular","mode":"center","href":"/spark/overview"}]},{"item":"Concepts","icon":"arrows-to-circle","pages":[{"title":"Spark: DataFrame","sidebarTitle":"DataFrame","icon":"table","iconType":"duotone","mode":"","href":"/spark/spark-dataframe"},{"title":"Spark: Dataset","sidebarTitle":"Dataset","icon":"calendar-days","iconType":"solid","mode":"","href":"/spark/spark-dataset"},{"title":"Spark: Resilient Distributed Datasets (RDDs)","sidebarTitle":"RDDs","icon":"cubes","iconType":"duotone","mode":"","href":"/spark/spark-rdd"},{"title":"Spark Session","sidebarTitle":"Spark Session","icon":"file-brackets-curly","iconType":"duotone","href":"/spark/spark-session"},{"title":"Spark: Shuffle Join","sidebarTitle":"Shuffle Join","icon":"shuffle","iconType":"regular","mode":"","href":"/spark/spark-shuffle-join"},{"title":"Spark: Datasets vs DataFrames","sidebarTitle":"Datasets vs DataFrames","icon":"table","iconType":"regular","mode":"","href":"/spark/spark-datasets-vs-dataframes"},{"title":"Spark: Transformations vs. Actions","sidebarTitle":"Transformations vs Actions","icon":"radiation","iconType":"duotone","mode":"","href":"/spark/spark-transformations-vs-actions"},{"title":"Spark: Collect vs Take","sidebarTitle":"Collect vs Take","icon":"cubes-stacked","iconType":"regular","mode":"","href":"/spark/spark-collect-vs-take"}]},{"item":"Optimization","icon":"arrow-up-right-dots","pages":[{"title":"Predicate Pushdown in Spark","sidebarTitle":"Predicate Pushdown","icon":"arrow-down-wide-short","iconType":"regular","mode":"wide","href":"/spark/spark-predicate-pushdown"}]},{"item":"Reference","icon":"code","pages":[{"title":"Spark Session Builder","sidebarTitle":"Spark session builder","icon":"wrench","iconType":"duotone","mode":"","href":"/spark/spark-sessionbuilder"},{"title":"Spark: select Function","sidebarTitle":"select()","icon":"ballot-check","iconType":"duotone","mode":"","href":"/spark/spark-select"},{"title":"Spark: selectExpr Function","sidebarTitle":"selectExpr()","icon":"check-double","iconType":"duotone","mode":"","href":"/spark/spark-selectexpr"},{"title":"Spark: lit function","sidebarTitle":"lit()","icon":"highlighter","iconType":"duotone","mode":"","href":"/spark/spark-lit"},{"title":"Spark: col Function","sidebarTitle":"col()","icon":"columns-3","iconType":"duotone","mode":"","href":"/spark/spark-col"},{"title":"Spark: columns Attribute","sidebarTitle":"columns","icon":"table-columns","iconType":"duotone","mode":"","href":"/spark/spark-columns"},{"title":"Spark: alias function","sidebarTitle":"alias()","icon":"clone","iconType":"duotone","mode":"","href":"/spark/spark-alias"},{"title":"Spark: describe function","sidebarTitle":"describe()","icon":"subtitles","iconType":"duotone","mode":"","href":"/spark/spark-describe"},{"title":"Spark: dtypes attribute","sidebarTitle":"dtypes","icon":"text-width","iconType":"duotone","mode":"","href":"/spark/spark-dtypes"},{"title":"Spark: printSchema function","sidebarTitle":"printSchema()","icon":"sitemap","iconType":"duotone","mode":"","href":"/spark/spark-printschema"},{"title":"Spark: explain function","sidebarTitle":"explain()","icon":"book-open","iconType":"duotone","mode":"","href":"/spark/spark-explain"},{"title":"Spark: drop function","sidebarTitle":"drop()","icon":"droplet","iconType":"duotone","mode":"","href":"/spark/spark-drop"},{"title":"Spark: dropDuplicates function","sidebarTitle":"dropDuplicates()","icon":"clone","iconType":"duotone","mode":"","href":"/spark/spark-dropduplicates"},{"title":"Spark: filter or where function","sidebarTitle":"filter()","icon":"filter","iconType":"duotone","mode":"","href":"/spark/spark-filter"},{"title":"Spark: withColumnRenamed() function","sidebarTitle":"withColumnRenamed()","icon":"signature","iconType":"duotone","mode":"","href":"/spark/spark-withcolumnrenamed"},{"title":"Spark: when function","sidebarTitle":"when()","icon":"clipboard-question","iconType":"duotone","mode":"","href":"/spark/spark-when"},{"title":"Spark: groupBy function","sidebarTitle":"groupBy()","icon":"object-group","iconType":"duotone","mode":"","href":"/spark/spark-groupby"},{"title":"Spark: join function","sidebarTitle":"join()","icon":"link","iconType":"duotone","mode":"","href":"/spark/spark-join"},{"title":"Spark: pivot function","sidebarTitle":"pivot()","icon":"table-pivot","iconType":"duotone","href":"/spark/spark-pivot"},{"title":"Spark: union function","sidebarTitle":"union()","icon":"object-ungroup","iconType":"duotone","mode":"","href":"/spark/spark-union"},{"title":"Spark: window functions","sidebarTitle":"window functions","icon":"window","iconType":"duotone","mode":"","href":"/spark/spark-window"},{"title":"Spark: broadcast function","sidebarTitle":"broadcast()","icon":"satellite-dish","iconType":"duotone","mode":"","href":"/spark/spark-broadcast"},{"title":"Spark: cache function","sidebarTitle":"cache()","icon":"database","iconType":"duotone","mode":"","href":"/spark/spark-cache"},{"title":"Spark: display() function","sidebarTitle":"display()","icon":"eye","iconType":"duotone","mode":"","href":"/spark/spark-display"},{"title":"Spark: explode function","sidebarTitle":"explode()","icon":"bomb","iconType":"duotone","mode":"","href":"/spark/spark-explode"}]}]},{"tab":"SQL","icon":"database","hidden":true,"menu":[{"item":"Getting Started","icon":"book-open","pages":[{"title":"SQL: Overview","sidebarTitle":"Overview","icon":"star","iconType":"regular","mode":"center","href":"/sql/overview"},{"title":"SQL query order of execution","sidebarTitle":"Order of Execution in SQL","icon":"arrow-progress","iconType":"regular","mode":null,"href":"/sql/sql-query-order-of-execution"}]},{"item":"SQL 101","icon":"graduation-cap","pages":[{"title":"SQL 101: Essential Concepts","sidebarTitle":"SQL Essential Concepts","icon":"database","iconType":"regular","mode":null,"href":"/sql/sql-essential-concepts"},{"title":"Read data in SQL","sidebarTitle":"Read data","icon":"book","iconType":"regular","mode":null,"href":"/sql/read-data-in-sql"},{"title":"Aggregation in SQL","sidebarTitle":"Aggregation","icon":"sigma","iconType":"regular","mode":null,"href":"/sql/aggregations-in-sql"},{"title":"Understanding Joins in SQL","sidebarTitle":"Joins","icon":"object-exclude","iconType":"regular","mode":null,"href":"/sql/joins-in-sql"},{"title":"Subqueries in SQL","sidebarTitle":"Subqueries","icon":"arrows-repeat-1","iconType":"regular","mode":null,"href":"/sql/subqueries-in-sql"},{"title":"Working with Data","sidebarTitle":"Working with Data","icon":"pen-to-square","iconType":"regular","mode":null,"href":"/sql/working-with-data"},{"title":"Creating and Modifying Tables","sidebarTitle":"Create and Modify Tables","icon":"table-cells","iconType":"regular","mode":null,"href":"/sql/creating-and-modifying-tables"},{"title":"Relationships Between Tables","sidebarTitle":"Relationships","icon":"link-horizontal","iconType":"regular","mode":null,"href":"/sql/relationships-between-tables"}]},{"item":"SQL Reference","icon":"code","pages":[{"title":"FROM Clause in SQL","sidebarTitle":"FROM","icon":"database","iconType":"duotone","mode":"","href":"/sql/sql-from-clause"},{"title":"WHERE Clause in SQL","sidebarTitle":"WHERE","icon":"database","iconType":"duotone","mode":"","href":"/sql/sql-where-clause"},{"title":"HAVING Clause in SQL","sidebarTitle":"HAVING Clause","icon":"database","iconType":"duotone","mode":"","href":"/sql/sql-having-clause"},{"title":"ORDER BY Clause in SQL","sidebarTitle":"ORDER BY clause","icon":"database","iconType":"duotone","mode":"","href":"/sql/sql-order-by-clause"},{"title":"LIMIT Clause in SQL","sidebarTitle":"LIMIT Clause","icon":"database","iconType":"duotone","mode":"","href":"/sql/sql-limit-clause"},{"title":"JOIN in SQL","sidebarTitle":"JOIN","icon":"database","iconType":"duotone","mode":"","href":"/sql/sql-join-operator"},{"title":"INNER JOIN in SQL","sidebarTitle":"INNER JOIN","icon":"database","iconType":"duotone","mode":"","href":"/sql/sql-inner-join"},{"title":"LEFT JOIN in SQL","sidebarTitle":"LEFT JOIN","icon":"database","iconType":"duotone","mode":"","href":"/sql/sql-left-join"},{"title":"UNION Clause in SQL","sidebarTitle":"UNION Clause","icon":"database","iconType":"duotone","mode":"","href":"/sql/sql-union-clause"},{"title":"Logical Operators in SQL","sidebarTitle":"Logical Operators","icon":"database","iconType":"duotone","mode":"","href":"/sql/sql-logical-operators"},{"title":"CASE expression in SQL","sidebarTitle":"CASE expression","icon":"database","iconType":"duotone","mode":"","href":"/sql/sql-case-expression"}]}]},{"tab":"Python","icon":"python","hidden":true,"menu":[{"item":"Fundamentals","icon":"book-open","pages":[{"title":"Python: Overview","sidebarTitle":"Overview","icon":"star","iconType":"regular","mode":"center","href":"/python/overview"},{"title":"Python Expressions","sidebarTitle":"Expressions","icon":"python","iconType":"duotone","mode":"","href":"/python/python-expression"},{"title":"Python Statements","sidebarTitle":"Statements","icon":"python","iconType":"duotone","mode":"","href":"/python/python-statement"},{"title":"Python Variables","sidebarTitle":"Variables","icon":"python","iconType":"duotone","mode":"","href":"/python/python-variable"},{"title":"Python Strings","sidebarTitle":"Strings","icon":"python","iconType":"duotone","mode":"","href":"/python/python-string"},{"title":"Python Lists","sidebarTitle":"Lists","icon":"python","iconType":"duotone","mode":"","href":"/python/python-list"},{"title":"Python Tuples","sidebarTitle":"Tuple","icon":"python","iconType":"duotone","mode":"","href":"/python/python-tuple"},{"title":"Python Dictionaries","sidebarTitle":"Dictionaries","icon":"python","iconType":"duotone","mode":"","href":"/python/python-dictionary"},{"title":"Python Conditionals","sidebarTitle":"Conditionals","icon":"python","iconType":"duotone","mode":"","href":"/python/python-conditional"},{"title":"Python Loops and Iterations","sidebarTitle":"Loops","icon":"python","iconType":"duotone","mode":"","href":"/python/python-loop"},{"title":"Python Functions","sidebarTitle":"Functions","icon":"python","iconType":"duotone","mode":"","href":"/python/python-function"},{"title":"Python: Working with Files","sidebarTitle":"Working with Files","icon":"python","iconType":"duotone","mode":"","href":"/python/python-working-with-files"}]},{"item":"Learn by Examples","icon":"lightbulb","pages":[{"title":"Python: Guide","sidebarTitle":"Python Guide","icon":"python","iconType":"regular","mode":"wide","href":"/python/python-guide"},{"title":"Python List Examples","sidebarTitle":"Python List Examples","icon":"brackets-square","iconType":"duotone","mode":"","href":"/python/python-list-examples"},{"title":"Python Tuple Examples","sidebarTitle":"Python Tuple Examples","icon":"brackets-round","iconType":"duotone","mode":"","href":"/python/python-tuple-examples"},{"title":"Python Function Examples","sidebarTitle":"Python Function Examples","icon":"function","iconType":"duotone","mode":"","href":"/python/python-function-examples"}]}]},{"tab":"DAX","icon":"superscript","hidden":true,"groups":[{"group":"DAX","pages":[{"title":"Mastering DAX Basics","sidebarTitle":"Mastering DAX Basics","icon":"star","iconType":"duotone","mode":"wide","href":"/dax/mastering-dax-basics"},{"title":"Understanding Calculated Columns and Measures in DAX","icon":"star","iconType":"duotone","mode":"wide","href":"/dax/calculated-columns-vs-measures"},{"title":"Mastering DAX Context: Understanding Row, Filter, and Evaluation Context","sidebarTitle":"DAX Contexts","icon":"star","iconType":"duotone","mode":"wide","href":"/dax/mastering-dax-context"},{"title":"Data Modeling in DAX","sidebarTitle":"Data Modeling in DAX","icon":"star","iconType":"duotone","mode":"wide","href":"/dax/data-modeling-in-dax"}]}]},{"tab":"Notes","icon":"notebook","hidden":true,"menu":[{"item":"Data Engineering","icon":"gear","groups":[{"group":"Intro to Data Engineering","pages":[{"title":"Introduction to Data Engineering: Overview","sidebarTitle":"Overview","icon":"pipe-valve","iconType":"duotone","mode":"","href":"/notes/intro-to-data-engineering/intro-to-data-engineering"},{"title":"Data Engineering Lifecycle","sidebarTitle":"Lifecycle","icon":"recycle","iconType":"duotone","mode":"","href":"/notes/intro-to-data-engineering/data-engineering-lifecycle"},{"title":"Data Engineering Undercurrents","sidebarTitle":"Undercurrents","icon":"dumbbell","iconType":"duotone","mode":"","href":"/notes/intro-to-data-engineering/data-engineering-undercurrents"},{"title":"Data Architecture","sidebarTitle":"Data Architecture","icon":"sitemap","iconType":"duotone","mode":"","href":"/notes/intro-to-data-engineering/data-architecture"},{"title":"Choosing Right Technologies","sidebarTitle":"Right Technologies","icon":"toolbox","iconType":"duotone","mode":"","href":"/notes/intro-to-data-engineering/choose-right-technology"},{"title":"Requirements Gathering","sidebarTitle":"Requirements Gathering","icon":"headset","iconType":"duotone","mode":"","href":"/notes/intro-to-data-engineering/requirements-gathering"}]},{"group":"Data Pipelines","pages":[{"title":"Source Systems","sidebarTitle":"Source Systems","icon":"files","iconType":"duotone","mode":"","href":"/notes/source-systems-data-ingestion-and-pipelines/source-systems"},{"title":"Data Ingestion","sidebarTitle":"Data Ingestion","icon":"file-export","iconType":"duotone","mode":"","href":"/notes/source-systems-data-ingestion-and-pipelines/data-ingestion"}]}]}]},{"tab":"Interview","icon":"user-tie","hidden":true,"menu":[{"item":"Start Here","icon":"flag","groups":[{"group":"Interview Prep","pages":[{"title":"Overview","href":"/interview/overview"}]},{"group":"SQL","pages":[{"title":"How to get nth highest salary in SQL Server?","sidebarTitle":"Nth Highest Salary","icon":"money-bill","iconType":"duotone","mode":"wide","href":"/sql/how-to-get-nth-highest-salary-in-sql"},{"title":"How to swap column value in SQL?","sidebarTitle":"Swap column values","icon":"swap","iconType":"duotone","mode":"wide","href":"/sql/how-to-swap-column-value-in-sql"}]},{"group":"Data Factory","pages":[{"title":"SSIS to ADF Migration Questions","sidebarTitle":"ADF Migration","icon":"turn-down-right","iconType":"duotone","mode":"wide","href":"/data-factory/adf-migration-questions"}]}]},{"item":"SQL Questions","icon":"database","pages":[{"title":"Sql","href":"/interview/sql"},{"title":"How to get nth highest salary in SQL Server?","sidebarTitle":"Nth Highest Salary","icon":"money-bill","iconType":"duotone","mode":"wide","href":"/sql/how-to-get-nth-highest-salary-in-sql"},{"title":"How to swap column value in SQL?","sidebarTitle":"Swap column values","icon":"swap","iconType":"duotone","mode":"wide","href":"/sql/how-to-swap-column-value-in-sql"}]},{"item":"Data Factory","icon":"pipe-circle-check","pages":[{"title":"SSIS to ADF Migration Questions","sidebarTitle":"ADF Migration","icon":"turn-down-right","iconType":"duotone","mode":"wide","href":"/data-factory/adf-migration-questions"}]}]},{"tab":"Glossary","icon":"rectangle-barcode","hidden":true,"menu":[{"item":"Overview","icon":"flag","groups":[{"group":"Data Basics","pages":[{"title":"Glossary: Overview","sidebarTitle":"Overview","icon":"star","iconType":"regular","mode":"custom","href":"/glossary/overview"},{"title":"ACID Properties","sidebarTitle":"ACID Properties","icon":"hand-fist","iconType":"regular","mode":"wide","href":"/glossary/acid-properties"},{"title":"Availability","sidebarTitle":"Availability","icon":"wifi-fair","iconType":"duotone","mode":"wide","href":"/glossary/availability"},{"title":"Big Data","sidebarTitle":"Big Data","icon":"expand","iconType":"duotone","mode":"wide","href":"/glossary/big-data"},{"title":"CAP Theorem","sidebarTitle":"CAP Theorem","icon":"circle-nodes","iconType":"duotone","mode":"wide","href":"/glossary/cap-theorem"},{"title":"Consistency","sidebarTitle":"Consistency","icon":"floppy-disk-circle-arrow-right","iconType":"duotone","mode":"wide","href":"/glossary/consistency"},{"title":"Data Analytics","sidebarTitle":"Data Analytics","icon":"magnifying-glass-chart","iconType":"duotone","mode":"wide","href":"/glossary/data-analytics"},{"title":"Data Engineering","sidebarTitle":"Data Engineering","icon":"pipe-circle-check","iconType":"duotone","mode":"wide","href":"/glossary/data-engineering"},{"title":"Data Science","sidebarTitle":"Data Science","icon":"atom-simple","iconType":"duotone","mode":"wide","href":"/glossary/data-science"},{"title":"Database","sidebarTitle":"Database","icon":"database","iconType":"duotone","mode":"wide","href":"/glossary/database"},{"title":"DBMS: Database Management System","sidebarTitle":"DBMS","icon":"server","iconType":"regular","mode":"wide","href":"/glossary/dbms"},{"title":"Distributed System","sidebarTitle":"Distributed System","icon":"computer-classic","iconType":"regular","mode":"wide","href":"/glossary/distributed-system"},{"title":"Encoding","sidebarTitle":"Encoding","icon":"file-zip","iconType":"duotone","mode":"wide","href":"/glossary/encoding"},{"title":"ETL: Extract, Transform, Load","sidebarTitle":"ETL","icon":"gear-code","iconType":"duotone","mode":"wide","href":"/glossary/etl"},{"title":"ELT: Extract, Load, Transform","sidebarTitle":"ELT","icon":"house-flood-water-circle-arrow-right","iconType":"duotone","mode":"wide","href":"/glossary/elt"},{"title":"Fault Tolerance","sidebarTitle":"Fault Tolerance","icon":"triangle-exclamation","iconType":"regular","mode":"wide","href":"/glossary/fault-tolerance"},{"title":"Lazy evaluation","sidebarTitle":"Lazy evaluation","icon":"diagram-project","iconType":"regular","mode":"wide","href":"/glossary/lazy-evaluation"},{"title":"NoSQL databases","sidebarTitle":"NoSQL","icon":"file-circle-xmark","iconType":"duotone","mode":"wide","href":"/glossary/nosql"},{"title":"OLAP: Online Analytical Processing","sidebarTitle":"OLAP","icon":"display-chart-up-circle-dollar","iconType":"duotone","mode":"wide","href":"/glossary/olap"},{"title":"OLTP: Online Transaction Processing","sidebarTitle":"OLTP","icon":"money-from-bracket","iconType":"duotone","mode":"wide","href":"/glossary/oltp"},{"title":"Reliability","sidebarTitle":"Reliability","icon":"hexagon-exclamation","iconType":"duotone","mode":"wide","href":"/glossary/reliability"},{"title":"Scalability","sidebarTitle":"Scalability","icon":"spinner-scale","iconType":"regular","mode":"wide","href":"/glossary/scalability"}]},{"group":"Data Storage \u0026 Formats","pages":[{"title":"ADLS: Azure Data Lake Storage","sidebarTitle":"ADLS","icon":"water-arrow-down","iconType":"duotone","mode":"wide","href":"/glossary/adls"},{"title":"ORC: Optimized Row Columnar File Format","sidebarTitle":"ORC","icon":"file-dashed-line","iconType":"duotone","mode":"wide","href":"/glossary/apache-orc"},{"title":"CSV File Format","sidebarTitle":"CSV","icon":"file-csv","iconType":"duotone","mode":"wide","href":"/glossary/csv"},{"title":"Delta Lake","sidebarTitle":"Delta Lake","icon":"house-flood-water","iconType":"regular","mode":null,"href":"/glossary/delta-lake"},{"title":"Distributed File Systems","sidebarTitle":"Distributed File Systems","icon":"table-tree","iconType":"duotone","mode":"wide","href":"/glossary/distributed-file-system"},{"title":"HDFS: Hadoop Distributed File System","sidebarTitle":"HDFS","icon":"folder-tree","iconType":"duotone","mode":"wide","href":"/glossary/hdfs"},{"title":"JSON File Format","sidebarTitle":"JSON","icon":"file-lines","iconType":"regular","mode":"wide","href":"/glossary/json"},{"title":"Amazon S3","sidebarTitle":"Amazon S3","icon":"bucket","iconType":"duotone","mode":"wide","href":"/glossary/s3"},{"title":"Schema Enforcement","sidebarTitle":"Schema Enforcement","icon":"table-cells-column-lock","iconType":"duotone","mode":"wide","href":"/glossary/schema-enforcement"},{"title":"Schema Evolution","sidebarTitle":"Schema Evolution","icon":"columns-3","iconType":"duotone","mode":"wide","href":"/glossary/schema-evolution"},{"title":"Schema-on-Read","sidebarTitle":"Schema-on-Read","icon":"table-layout","iconType":"duotone","mode":"wide","href":"/glossary/schema-on-read"},{"title":"Schema-on-Write","sidebarTitle":"Schema-on-Write","icon":"table-columns","iconType":"duotone","mode":"wide","href":"/glossary/schema-on-write"},{"title":"Storage","sidebarTitle":"Storage","icon":"floppy-disk","iconType":"duotone","mode":"wide","href":"/glossary/storage"},{"title":"XML File Format","sidebarTitle":"XML","icon":"file-xml","iconType":"duotone","mode":"wide","href":"/glossary/xml"},{"title":"YAML File Format","sidebarTitle":"YAML File Format","icon":"file-check","iconType":"duotone","mode":"wide","href":"/glossary/yaml"}]},{"group":"Data Processing","pages":[{"title":"Apache Hadoop","sidebarTitle":"Apache Hadoop","icon":"elephant","iconType":"duotone","mode":"wide","href":"/glossary/apache-hadoop"},{"title":"Batch Processing","sidebarTitle":"Batch Processing","icon":"stopwatch-20","iconType":"duotone","mode":"wide","href":"/glossary/batch-processing"},{"title":"Compute Engines","sidebarTitle":"Compute Engines","icon":"microchip","iconType":"duotone","mode":"wide","href":"/glossary/compute-engines"},{"title":"Data Processing","sidebarTitle":"Data Processing","icon":"microchip","iconType":"duotone","mode":"wide","href":"/glossary/data-processing"},{"title":"MapReduce","sidebarTitle":"MapReduce","icon":"diagram-predecessor","iconType":"duotone","mode":"wide","href":"/glossary/mapreduce"},{"title":"Stream Processing","sidebarTitle":"Stream Processing","icon":"signal-stream","iconType":"duotone","mode":"wide","href":"/glossary/stream-processing"}]},{"group":"Data Pipelines","pages":[{"title":"CDC: Change Data Capture","sidebarTitle":"Change Data Capture","icon":"cash-register","iconType":"duotone","mode":"wide","href":"/glossary/change-data-capture"},{"title":"Data Ingestion","sidebarTitle":"Data Ingestion","icon":"file-export","iconType":"duotone","mode":"wide","href":"/glossary/data-ingestion"},{"title":"Data Integration","sidebarTitle":"Data Integration","icon":"merge","iconType":"duotone","mode":"wide","href":"/glossary/data-integration"},{"title":"Data Orchestration","sidebarTitle":"Data Orchestration","icon":"truck-monster","iconType":"regular","mode":"wide","href":"/glossary/data-orchestration"},{"title":"Data Pipelines","sidebarTitle":"Data Pipelines","icon":"timeline-arrow","iconType":"duotone","mode":"wide","href":"/glossary/data-pipeline"},{"title":"Data Transformation","sidebarTitle":"Data Transformation","icon":"bolt","iconType":"duotone","mode":"wide","href":"/glossary/data-transformation"},{"title":"ETL: Extract, Transform, Load","sidebarTitle":"ETL","icon":"gear-code","iconType":"duotone","mode":"wide","href":"/glossary/etl"},{"title":"ELT: Extract, Load, Transform","sidebarTitle":"ELT","icon":"house-flood-water-circle-arrow-right","iconType":"duotone","mode":"wide","href":"/glossary/elt"}]},{"group":"Data Governance","pages":[{"title":"Data Catalog","sidebarTitle":"Data Catalog","icon":"rectangle-history","iconType":"duotone","mode":"wide","href":"/glossary/data-catalog"},{"title":"Data Discovery","sidebarTitle":"Data Discovery","icon":"folder-magnifying-glass","iconType":"duotone","mode":"wide","href":"/glossary/data-discovery"},{"title":"Data Governance","sidebarTitle":"Data Governance","icon":"building-user","iconType":"duotone","mode":"wide","href":"/glossary/data-governance"},{"title":"Data Lineage","sidebarTitle":"Data Lineage","icon":"network-wired","iconType":"duotone","mode":"wide","href":"/glossary/data-lineage"},{"title":"Data Mapping","sidebarTitle":"Data Mapping","icon":"object-exclude","iconType":"duotone","mode":"wide","href":"/glossary/data-mapping"},{"title":"Data Quality","sidebarTitle":"Data Quality","icon":"ranking-star","iconType":"duotone","mode":"wide","href":"/glossary/data-quality"},{"title":"Metadata Management","sidebarTitle":"Metadata Management","icon":"folder-tree","iconType":"duotone","mode":"wide","href":"/glossary/metadata-management"},{"title":"Unity Catalog","sidebarTitle":"Unity Catalog","icon":"album-collection-circle-user","iconType":"duotone","mode":"wide","href":"/glossary/unity-catalog"}]},{"group":"Cloud","pages":[{"title":"Cloud Computing","sidebarTitle":"Cloud Computing","icon":"cloud-binary","iconType":"duotone","mode":"wide","href":"/glossary/cloud-computing"},{"title":"Cloud Data Warehouse","sidebarTitle":"Cloud Data Warehouse","icon":"sensor-cloud","iconType":"duotone","mode":"wide","href":"/glossary/cloud-data-warehouse"},{"title":"Cloud Native","sidebarTitle":"Cloud Native","icon":"cloud-check","iconType":"duotone","mode":"wide","href":"/glossary/cloud-native"},{"title":"Cloud Object Storage","sidebarTitle":"Cloud Object Storage","icon":"bucket","iconType":"duotone","mode":"wide","href":"/glossary/cloud-object-storage"},{"title":"Consensus algorithms","sidebarTitle":"Consensus algorithms","icon":"bullhorn","iconType":"duotone","mode":"wide","href":"/glossary/consensus-algorithms"},{"title":"Distributed File Systems","sidebarTitle":"Distributed File Systems","icon":"table-tree","iconType":"duotone","mode":"wide","href":"/glossary/distributed-file-system"},{"title":"Distributed System","sidebarTitle":"Distributed System","icon":"computer-classic","iconType":"regular","mode":"wide","href":"/glossary/distributed-system"},{"title":"IaaS: Infrastructure as a Service","sidebarTitle":"IaaS","icon":"network-wired","iconType":"duotone","mode":"wide","href":"/glossary/iaas"},{"title":"PaaS: Platform as a Service","sidebarTitle":"PaaS","icon":"layer-group","iconType":"duotone","mode":"wide","href":"/glossary/paas"},{"title":"Software as a Service","sidebarTitle":"Software as a Service","icon":"mobile-screen-button","iconType":"duotone","mode":"wide","href":"/glossary/saas"},{"title":"FaaS: Function as a Service","sidebarTitle":"FaaS","icon":"function","iconType":"duotone","mode":"wide","href":"/glossary/faas"},{"title":"Serverless Computing","sidebarTitle":"Serverless Computing","icon":"cloud-binary","iconType":"duotone","mode":"wide","href":"/glossary/serverless-computing"},{"title":"Virtual Machine","sidebarTitle":"Virtual Machine","icon":"cloud-binary","iconType":"duotone","mode":"wide","href":"/glossary/virtual-machine"}]},{"group":"Data Warehousing","pages":[{"title":"Data Lake","sidebarTitle":"Data Lake","icon":"water","iconType":"regular","mode":"wide","href":"/glossary/data-lake"},{"title":"Data Lakehouse","sidebarTitle":"Data Lakehouse","icon":"house-water","iconType":"regular","mode":"wide","href":"/glossary/data-lakehouse"},{"title":"Data Mart","sidebarTitle":"Data Mart","icon":"grip","iconType":"regular","mode":"wide","href":"/glossary/data-mart"},{"title":"Data Warehouse","sidebarTitle":"Data Warehouse","icon":"warehouse-full","iconType":"duotone","mode":"wide","href":"/glossary/data-warehouse"},{"title":"Apache Hudi","sidebarTitle":"Apache Hudi","icon":"droplet-percent","iconType":"duotone","mode":"wide","href":"/glossary/apache-hudi"},{"title":"Apache Iceberg","sidebarTitle":"Apache Iceberg","icon":"icicles","iconType":"duotone","mode":"wide","href":"/glossary/apache-iceberg"},{"title":"Medallion Architecture","sidebarTitle":"Medallion Architecture","icon":"medal","iconType":"duotone","mode":"wide","href":"/glossary/medallion-architecture"},{"title":"Operational Data Store","sidebarTitle":"Operational Data Store","icon":"garage-open","iconType":"duotone","mode":"wide","href":"/glossary/operational-data-store"}]},{"group":"Data Analytics","pages":[{"title":"Business Intelligence","sidebarTitle":"Business Intelligence","icon":"chart-mixed-up-circle-dollar","iconType":"duotone","mode":"wide","href":"/glossary/business-intelligence"},{"title":"Data Visualization","sidebarTitle":"Data Visualization","icon":"chart-scatter-bubble","iconType":"duotone","mode":"wide","href":"/glossary/data-visualization"},{"title":"OLAP: Online Analytical Processing","sidebarTitle":"OLAP","icon":"display-chart-up-circle-dollar","iconType":"duotone","mode":"wide","href":"/glossary/olap"},{"title":"Self-Service Analytics","sidebarTitle":"Self-Service Analytics","icon":"chart-mixed-up-circle-dollar","iconType":"duotone","mode":"wide","href":"/glossary/self-service-analytics"}]},{"group":"Artificial Intelligence","pages":[{"title":"Artificial Intelligence","sidebarTitle":"Artificial Intelligence","icon":"microchip-ai","iconType":"duotone","mode":"wide","href":"/glossary/artificial-intelligence"},{"title":"Deep Learning","sidebarTitle":"Deep Learning","icon":"crosshairs","iconType":"duotone","mode":"wide","href":"/glossary/deep-learning"},{"title":"Generative AI","sidebarTitle":"Gen AI","icon":"symbols","iconType":"duotone","mode":"wide","href":"/glossary/generative-ai"},{"title":"LLMs: Large Language Models","sidebarTitle":"Large Language Models","icon":"cloud-binary","iconType":"duotone","mode":"wide","href":"/glossary/large-language-models"},{"title":"Machine Learning","sidebarTitle":"Machine Learning","icon":"slot-machine","iconType":"duotone","mode":"wide","href":"/glossary/machine-learning"},{"title":"Machine Learning Models","sidebarTitle":"Machine Learning Models","icon":"icons","iconType":"duotone","mode":"wide","href":"/glossary/machine-learning-models"}]},{"group":"Networking and Security","pages":[{"title":"Authentication","sidebarTitle":"Authentication","icon":"key","iconType":"duotone","mode":"wide","href":"/glossary/authentication"},{"title":"Authorization","sidebarTitle":"Authorization","icon":"user-shield","iconType":"duotone","mode":"wide","href":"/glossary/authorization"},{"title":"Data Security","sidebarTitle":"Data Security","icon":"shield-halved","iconType":"duotone","mode":"wide","href":"/glossary/data-security"},{"title":"Data Sovereignty","sidebarTitle":"Data Sovereignty","icon":"location-check","iconType":"duotone","mode":"wide","href":"/glossary/data-sovereignty"},{"title":"Disaster Recovery","sidebarTitle":"Disaster Recovery","icon":"tornado","iconType":"duotone","mode":"wide","href":"/glossary/disaster-recovery"},{"title":"Encryption","sidebarTitle":"Encryption","icon":"lock","iconType":"duotone","mode":"wide","href":"/glossary/encryption"},{"title":"Load Balancing","sidebarTitle":"Load Balancing","icon":"scale-balanced","iconType":"duotone","mode":"wide","href":"/glossary/load-balancing"},{"title":"TCP/IP Protocol","sidebarTitle":"TCP/IP","icon":"globe-pointer","iconType":"duotone","mode":"wide","href":"/glossary/tcp-ip-protocol"}]}]},{"item":"Data Basics","icon":"database","pages":[{"title":"Database","sidebarTitle":"Database","icon":"database","iconType":"duotone","mode":"wide","href":"/glossary/database"}]},{"item":"Data Storage \u0026 Formats","icon":"file","pages":[{"title":"Distributed File Systems","sidebarTitle":"Distributed File Systems","icon":"table-tree","iconType":"duotone","mode":"wide","href":"/glossary/distributed-file-system"}]},{"item":"Data Processing","icon":"gear-code","pages":[{"title":"Data Processing","sidebarTitle":"Data Processing","icon":"microchip","iconType":"duotone","mode":"wide","href":"/glossary/data-processing"}]},{"item":"Data Pipelines","icon":"pipe-valve","pages":[{"title":"Data Pipelines","sidebarTitle":"Data Pipelines","icon":"timeline-arrow","iconType":"duotone","mode":"wide","href":"/glossary/data-pipeline"}]},{"item":"Data Governance","icon":"user-police","pages":[{"title":"Data Governance","sidebarTitle":"Data Governance","icon":"building-user","iconType":"duotone","mode":"wide","href":"/glossary/data-governance"}]},{"item":"Cloud","icon":"cloud","pages":[{"title":"Cloud Computing","sidebarTitle":"Cloud Computing","icon":"cloud-binary","iconType":"duotone","mode":"wide","href":"/glossary/cloud-computing"}]},{"item":"Data Warehousing","icon":"garage","pages":[{"title":"Data Warehouse","sidebarTitle":"Data Warehouse","icon":"warehouse-full","iconType":"duotone","mode":"wide","href":"/glossary/data-warehouse"}]},{"item":"Artificial Intelligence","icon":"microchip-ai","pages":[{"title":"Artificial Intelligence","sidebarTitle":"Artificial Intelligence","icon":"microchip-ai","iconType":"duotone","mode":"wide","href":"/glossary/artificial-intelligence"}]}]}]},{"version":"๐ Growth","hidden":true,"pages":[{"title":"๐ Growth","href":"/book-summary/atomic-habits","hidden":true}]}]},"basePath":"","title":"How to generate numbers table in SQL? - Rajanand","deploymentId":"dpl_DyXGnKeCjZyA3sUdfMJ7FjkdBefg","buildId":"dpl_DyXGnKeCjZyA3sUdfMJ7FjkdBefg","dynamics":[],"chunks":[]}