{"id":24168,"date":"2022-11-30T20:35:56","date_gmt":"2022-11-30T15:05:56","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/"},"modified":"2022-11-30T20:35:56","modified_gmt":"2022-11-30T15:05:56","slug":"solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/","title":{"rendered":"[Solved] Selecting distinct values from multiple column of a table with their count"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-28248949\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"28248949\" data-parentid=\"28248921\" data-score=\"-2\" data-position-on-page=\"3\" 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>Get all column values to one row and find the count    <\/p>\n<p><strong>SQL SERVER<\/strong> <\/p>\n<pre><code>;WITH CTE AS\n(\n   SELECT COL1 Name\n   FROM YOURTABLE\n   UNION ALL\n   SELECT COL2\n   FROM YOURTABLE\n   UNION ALL\n   SELECT COL3\n   FROM YOURTABLE\n   UNION ALL\n   SELECT COL4\n   FROM YOURTABLE\n   UNION ALL\n   SELECT COL6\n   FROM YOURTABLE\n   UNION ALL\n   SELECT COL7\n   FROM YOURTABLE\n)\nSELECT DISTINCT Name,COUNT(Name) OVER(PARTITION BY Name) [COUNT]\nFROM CTE \n<\/code><\/pre>\n<p><strong>MYSQL<\/strong><\/p>\n<pre><code>SELECT Name,COUNT(*) [COUNT]\n(\n   SELECT COL1 Name\n   FROM #TEMP\n   UNION ALL\n   SELECT COL2\n   FROM #TEMP  \n   UNION ALL\n   SELECT COL3\n   FROM #TEMP  \n   UNION ALL\n   SELECT COL4\n   FROM #TEMP  \n   UNION ALL\n   SELECT COL6\n   FROM #TEMP  \n   UNION ALL\n   SELECT COL7\n   FROM #TEMP      \n)TAB   \nGROUP BY Name\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">5<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Selecting distinct values from multiple column of a table with their count <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Get all column values to one row and find the count SQL SERVER ;WITH CTE AS ( SELECT COL1 Name FROM YOURTABLE UNION ALL SELECT COL2 FROM YOURTABLE UNION ALL SELECT COL3 FROM YOURTABLE UNION ALL SELECT COL4 FROM YOURTABLE UNION ALL SELECT COL6 FROM YOURTABLE UNION ALL SELECT COL7 FROM YOURTABLE ) SELECT &#8230; <a title=\"[Solved] Selecting distinct values from multiple column of a table with their count\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/\" aria-label=\"More on [Solved] Selecting distinct values from multiple column of a table with their count\">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":[546,473,340,341,500],"class_list":["post-24168","post","type-post","status-publish","format-standard","hentry","category-solved","tag-database","tag-ms-access","tag-mysql","tag-sql","tag-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Selecting distinct values from multiple column of a table with their count - 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-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Selecting distinct values from multiple column of a table with their count - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Get all column values to one row and find the count SQL SERVER ;WITH CTE AS ( SELECT COL1 Name FROM YOURTABLE UNION ALL SELECT COL2 FROM YOURTABLE UNION ALL SELECT COL3 FROM YOURTABLE UNION ALL SELECT COL4 FROM YOURTABLE UNION ALL SELECT COL6 FROM YOURTABLE UNION ALL SELECT COL7 FROM YOURTABLE ) SELECT ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-30T15:05:56+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-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Selecting distinct values from multiple column of a table with their count\",\"datePublished\":\"2022-11-30T15:05:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/\"},\"wordCount\":42,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"database\",\"ms-access\",\"mysql\",\"sql\",\"sql-server\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/\",\"name\":\"[Solved] Selecting distinct values from multiple column of a table with their count - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-30T15:05:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Selecting distinct values from multiple column of a table with their count\"}]},{\"@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=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Selecting distinct values from multiple column of a table with their count - 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-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Selecting distinct values from multiple column of a table with their count - JassWeb","og_description":"[ad_1] Get all column values to one row and find the count SQL SERVER ;WITH CTE AS ( SELECT COL1 Name FROM YOURTABLE UNION ALL SELECT COL2 FROM YOURTABLE UNION ALL SELECT COL3 FROM YOURTABLE UNION ALL SELECT COL4 FROM YOURTABLE UNION ALL SELECT COL6 FROM YOURTABLE UNION ALL SELECT COL7 FROM YOURTABLE ) SELECT ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/","og_site_name":"JassWeb","article_published_time":"2022-11-30T15:05:56+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-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Selecting distinct values from multiple column of a table with their count","datePublished":"2022-11-30T15:05:56+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/"},"wordCount":42,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["database","ms-access","mysql","sql","sql-server"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/","url":"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/","name":"[Solved] Selecting distinct values from multiple column of a table with their count - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-30T15:05:56+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-selecting-distinct-values-from-multiple-column-of-a-table-with-their-count\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Selecting distinct values from multiple column of a table with their count"}]},{"@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=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","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\/24168","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=24168"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/24168\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=24168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=24168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=24168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}