{"id":26129,"date":"2022-12-15T21:30:59","date_gmt":"2022-12-15T16:00:59","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/"},"modified":"2022-12-15T21:30:59","modified_gmt":"2022-12-15T16:00:59","slug":"solved-please-help-me-create-sql-statement-for-my-tables-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/","title":{"rendered":"[Solved] Please help me create sql statement for my tables? [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-3741423\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"3741423\" data-parentid=\"3741401\" data-score=\"0\" data-position-on-page=\"2\" data-highest-scored=\"0\" data-question-has-accepted-highest-score=\"0\" itemprop=\"suggestedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>This gets your desired results. Not sure why you would desire them though! (particularly the completely made up id values 9 and 10)<\/p>\n<pre><code>;WITH Employee AS\n(\nselect 1 as ID, 'Alex' AS Name UNION ALL\nselect 2 as ID, 'James' AS Name UNION ALL\nselect 3 as ID, 'John' AS Name UNION ALL\nselect 4 as ID, 'Anthony' AS Name UNION ALL\nselect 5 as ID, 'Jack' AS Name\n),\nFamily AS\n(\nSELECT 1 AS ID, 'Kayla' AS Name, 'wife' AS Relative, 1 AS EmployeeID UNION ALL\nSELECT 2, 'Benjamin', 'Son',1 UNION ALL\nSELECT 3, 'Alyssa', 'wife',2 UNION ALL\nSELECT 4, 'Emma', 'daughter',2 UNION ALL\nSELECT 5, 'Emily', 'daughter',2 UNION ALL\nSELECT 6, 'Elizabeth', 'wife',5 UNION ALL\nSELECT 7, 'Jackson', 'Son',5 UNION ALL\nSELECT 8, 'Laura', 'daughter',5 \n),\ncte AS\n(\n\nSELECT f.ID, f.Name, f.Relative, e.ID EmployeeID,\nMAX(f.ID) OVER() + ROW_NUMBER() OVER (PARTITION BY f.ID ORDER BY e.ID) AS RN\nFROM Employee e LEFT OUTER JOIN Family f\nON e.ID = f.EmployeeId\n)\nSELECT COALESCE(ID,RN) AS ID, Name, Relative, EmployeeID \nFROM cte\nORDER BY ID\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Please help me create sql statement for my tables? [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] This gets your desired results. Not sure why you would desire them though! (particularly the completely made up id values 9 and 10) ;WITH Employee AS ( select 1 as ID, &#8216;Alex&#8217; AS Name UNION ALL select 2 as ID, &#8216;James&#8217; AS Name UNION ALL select 3 as ID, &#8216;John&#8217; AS Name UNION ALL &#8230; <a title=\"[Solved] Please help me create sql statement for my tables? [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/\" aria-label=\"More on [Solved] Please help me create sql statement for my tables? [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[341],"class_list":["post-26129","post","type-post","status-publish","format-standard","hentry","category-solved","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Please help me create sql statement for my tables? [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Please help me create sql statement for my tables? [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] This gets your desired results. Not sure why you would desire them though! (particularly the completely made up id values 9 and 10) ;WITH Employee AS ( select 1 as ID, &#039;Alex&#039; AS Name UNION ALL select 2 as ID, &#039;James&#039; AS Name UNION ALL select 3 as ID, &#039;John&#039; AS Name UNION ALL ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-15T16:00:59+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Please help me create sql statement for my tables? [closed]\",\"datePublished\":\"2022-12-15T16:00:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/\"},\"wordCount\":45,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"sql\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/\",\"name\":\"[Solved] Please help me create sql statement for my tables? [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-12-15T16:00:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Please help me create sql statement for my tables? [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Please help me create sql statement for my tables? [closed] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Please help me create sql statement for my tables? [closed] - JassWeb","og_description":"[ad_1] This gets your desired results. Not sure why you would desire them though! (particularly the completely made up id values 9 and 10) ;WITH Employee AS ( select 1 as ID, 'Alex' AS Name UNION ALL select 2 as ID, 'James' AS Name UNION ALL select 3 as ID, 'John' AS Name UNION ALL ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/","og_site_name":"JassWeb","article_published_time":"2022-12-15T16:00:59+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Please help me create sql statement for my tables? [closed]","datePublished":"2022-12-15T16:00:59+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/"},"wordCount":45,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["sql"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/","name":"[Solved] Please help me create sql statement for my tables? [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-12-15T16:00:59+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-please-help-me-create-sql-statement-for-my-tables-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Please help me create sql statement for my tables? [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/26129","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=26129"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/26129\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=26129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=26129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=26129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}