{"id":12,"date":"2009-09-14T14:28:13","date_gmt":"2009-09-14T14:28:13","guid":{"rendered":"http:\/\/anyons.net\/dev\/?p=12"},"modified":"2022-07-12T14:49:32","modified_gmt":"2022-07-12T05:49:32","slug":"select-%ec%8b%9c%ec%97%90-%ec%84%b8%eb%a1%9c%ed%96%89-%ec%b6%9c%eb%a0%a5%ec%9d%84-%ea%b0%80%eb%a1%9c%ed%96%89-%ec%b6%9c%eb%a0%a5%ec%9c%bc%eb%a1%9c-%eb%b3%80%ed%99%98","status":"publish","type":"post","link":"https:\/\/anyons.net\/?p=12","title":{"rendered":"select \uc2dc\uc5d0 \uc138\ub85c\ud589 \ucd9c\ub825\uc744 \uac00\ub85c\ud589 \ucd9c\ub825\uc73c\ub85c \ubcc0\ud658"},"content":{"rendered":"<p>\ucd9c\ucc98 : <a href=\"http:\/\/bomb.egloos.com\/1073673\">http:\/\/bomb.egloos.com\/1073673<\/a><\/p>\n<pre class=\"lang:c# decode:true \">SELECT\n\tMAX(DECODE(A, '1', B) as COL1,\n\tMAX(DECODE(A, '2', B) as COL2,\n\tMAX(DECODE(A, '3', B) as COL3\nFROM\n(\n\tSELECT A, B FROM [table]\n)<\/pre>\n\n","protected":false},"excerpt":{"rendered":"<p>\ucd9c\ucc98 : http:\/\/bomb.egloos.com\/1073673<\/p>\n<p> SELECT MAX(DECODE(A, &#8216;1&#8217;, B) as COL1, MAX(DECODE(A, &#8216;2&#8217;, B) as COL2, MAX(DECODE(A, &#8216;3&#8217;, B) as COL3 FROM ( SELECT A, B FROM [table] ) <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[96],"tags":[117,103],"class_list":["post-12","post","type-post","status-publish","format-standard","hentry","category-programming","tag-query","tag-sql","odd"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>select \uc2dc\uc5d0 \uc138\ub85c\ud589 \ucd9c\ub825\uc744 \uac00\ub85c\ud589 \ucd9c\ub825\uc73c\ub85c \ubcc0\ud658 - anydragon<\/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:\/\/anyons.net\/?p=12\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"select \uc2dc\uc5d0 \uc138\ub85c\ud589 \ucd9c\ub825\uc744 \uac00\ub85c\ud589 \ucd9c\ub825\uc73c\ub85c \ubcc0\ud658 - anydragon\" \/>\n<meta property=\"og:description\" content=\"\ucd9c\ucc98 : http:\/\/bomb.egloos.com\/1073673 SELECT MAX(DECODE(A, &#039;1&#039;, B) as COL1, MAX(DECODE(A, &#039;2&#039;, B) as COL2, MAX(DECODE(A, &#039;3&#039;, B) as COL3 FROM ( SELECT A, B FROM [table] )\" \/>\n<meta property=\"og:url\" content=\"https:\/\/anyons.net\/?p=12\" \/>\n<meta property=\"og:site_name\" content=\"anydragon\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/anydragon\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anydragon\" \/>\n<meta property=\"article:published_time\" content=\"2009-09-14T14:28:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-12T05:49:32+00:00\" \/>\n<meta name=\"author\" content=\"anydragon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@anydragon\" \/>\n<meta name=\"twitter:site\" content=\"@anydragon\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"anydragon\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=12#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=12\"},\"author\":{\"name\":\"anydragon\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"headline\":\"select \uc2dc\uc5d0 \uc138\ub85c\ud589 \ucd9c\ub825\uc744 \uac00\ub85c\ud589 \ucd9c\ub825\uc73c\ub85c \ubcc0\ud658\",\"datePublished\":\"2009-09-14T14:28:13+00:00\",\"dateModified\":\"2022-07-12T05:49:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=12\"},\"wordCount\":5,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"keywords\":[\"query\",\"sql\"],\"articleSection\":[\"Programming\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=12#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=12\",\"url\":\"https:\\\/\\\/anyons.net\\\/?p=12\",\"name\":\"select \uc2dc\uc5d0 \uc138\ub85c\ud589 \ucd9c\ub825\uc744 \uac00\ub85c\ud589 \ucd9c\ub825\uc73c\ub85c \ubcc0\ud658 - anydragon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\"},\"datePublished\":\"2009-09-14T14:28:13+00:00\",\"dateModified\":\"2022-07-12T05:49:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=12#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/anyons.net\\\/?p=12\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/anyons.net\\\/?p=12#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/anyons.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"select \uc2dc\uc5d0 \uc138\ub85c\ud589 \ucd9c\ub825\uc744 \uac00\ub85c\ud589 \ucd9c\ub825\uc73c\ub85c \ubcc0\ud658\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/anyons.net\\\/#website\",\"url\":\"https:\\\/\\\/anyons.net\\\/\",\"name\":\"anydragon\",\"description\":\"mac, linux, aws, c, c++, mysql, mssql, redis, csharp, nodejs, rust, golang\",\"publisher\":{\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/anyons.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/anyons.net\\\/#\\\/schema\\\/person\\\/e848d5666536ff82e9ee531c70249f2b\",\"name\":\"anydragon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"url\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"contentUrl\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\",\"width\":2560,\"height\":1440,\"caption\":\"anydragon\"},\"logo\":{\"@id\":\"http:\\\/\\\/anyons.net\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/bg3-scaled.jpeg\"},\"sameAs\":[\"http:\\\/\\\/anyons.net\",\"https:\\\/\\\/www.facebook.com\\\/anydragon\",\"https:\\\/\\\/x.com\\\/anydragon\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCr78KWpvmk398vPfpUTWNLg\"],\"url\":\"https:\\\/\\\/anyons.net\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"select \uc2dc\uc5d0 \uc138\ub85c\ud589 \ucd9c\ub825\uc744 \uac00\ub85c\ud589 \ucd9c\ub825\uc73c\ub85c \ubcc0\ud658 - anydragon","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:\/\/anyons.net\/?p=12","og_locale":"ko_KR","og_type":"article","og_title":"select \uc2dc\uc5d0 \uc138\ub85c\ud589 \ucd9c\ub825\uc744 \uac00\ub85c\ud589 \ucd9c\ub825\uc73c\ub85c \ubcc0\ud658 - anydragon","og_description":"\ucd9c\ucc98 : http:\/\/bomb.egloos.com\/1073673 SELECT MAX(DECODE(A, '1', B) as COL1, MAX(DECODE(A, '2', B) as COL2, MAX(DECODE(A, '3', B) as COL3 FROM ( SELECT A, B FROM [table] )","og_url":"https:\/\/anyons.net\/?p=12","og_site_name":"anydragon","article_publisher":"https:\/\/www.facebook.com\/anydragon","article_author":"https:\/\/www.facebook.com\/anydragon","article_published_time":"2009-09-14T14:28:13+00:00","article_modified_time":"2022-07-12T05:49:32+00:00","author":"anydragon","twitter_card":"summary_large_image","twitter_creator":"@anydragon","twitter_site":"@anydragon","twitter_misc":{"\uae00\uc4f4\uc774":"anydragon"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/anyons.net\/?p=12#article","isPartOf":{"@id":"https:\/\/anyons.net\/?p=12"},"author":{"name":"anydragon","@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"headline":"select \uc2dc\uc5d0 \uc138\ub85c\ud589 \ucd9c\ub825\uc744 \uac00\ub85c\ud589 \ucd9c\ub825\uc73c\ub85c \ubcc0\ud658","datePublished":"2009-09-14T14:28:13+00:00","dateModified":"2022-07-12T05:49:32+00:00","mainEntityOfPage":{"@id":"https:\/\/anyons.net\/?p=12"},"wordCount":5,"commentCount":0,"publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"keywords":["query","sql"],"articleSection":["Programming"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/anyons.net\/?p=12#respond"]}]},{"@type":"WebPage","@id":"https:\/\/anyons.net\/?p=12","url":"https:\/\/anyons.net\/?p=12","name":"select \uc2dc\uc5d0 \uc138\ub85c\ud589 \ucd9c\ub825\uc744 \uac00\ub85c\ud589 \ucd9c\ub825\uc73c\ub85c \ubcc0\ud658 - anydragon","isPartOf":{"@id":"https:\/\/anyons.net\/#website"},"datePublished":"2009-09-14T14:28:13+00:00","dateModified":"2022-07-12T05:49:32+00:00","breadcrumb":{"@id":"https:\/\/anyons.net\/?p=12#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/anyons.net\/?p=12"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/anyons.net\/?p=12#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/anyons.net\/"},{"@type":"ListItem","position":2,"name":"select \uc2dc\uc5d0 \uc138\ub85c\ud589 \ucd9c\ub825\uc744 \uac00\ub85c\ud589 \ucd9c\ub825\uc73c\ub85c \ubcc0\ud658"}]},{"@type":"WebSite","@id":"https:\/\/anyons.net\/#website","url":"https:\/\/anyons.net\/","name":"anydragon","description":"mac, linux, aws, c, c++, mysql, mssql, redis, csharp, nodejs, rust, golang","publisher":{"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/anyons.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":["Person","Organization"],"@id":"https:\/\/anyons.net\/#\/schema\/person\/e848d5666536ff82e9ee531c70249f2b","name":"anydragon","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","url":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","contentUrl":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg","width":2560,"height":1440,"caption":"anydragon"},"logo":{"@id":"http:\/\/anyons.net\/wp-content\/uploads\/2022\/06\/bg3-scaled.jpeg"},"sameAs":["http:\/\/anyons.net","https:\/\/www.facebook.com\/anydragon","https:\/\/x.com\/anydragon","https:\/\/www.youtube.com\/channel\/UCr78KWpvmk398vPfpUTWNLg"],"url":"https:\/\/anyons.net\/?author=1"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":35,"url":"https:\/\/anyons.net\/?p=35","url_meta":{"origin":12,"position":0},"title":"CxImage\uc5d0\uc11c try catch\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95","author":"anydragon","date":"2010\ub144 03\uc6d4 05\uc77c","format":false,"excerpt":"\u00a0 cx_try { ximage->Decode( _m_pbyRead + jpgInfo.unPointerStart, jpgInfo.unSize, CXIMAGE_FORMAT_JP2 ); } cx_catch { if ( strcmp(message,\"\") ) { TCHAR szMessage[255]; CAnyString::MBCS2Unicode( message, szMessage ); theLog( CAnyLog::LOG_ERROR, szMessage ); } } \u00a0","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2580,"url":"https:\/\/anyons.net\/?p=2580","url_meta":{"origin":12,"position":1},"title":"bootstrap\uc5d0\uc11c bootstrap-select \uc0ac\uc6a9\ud560\ub54c \uc0c1\uc704\uc5d0 \uc788\ub294 table-responsive\ub54c\ubb38\uc5d0 dropdown\uc774 \uc9e4\ub824 \ubcf4\uc77c\ub54c \uc0ac\uc6a9\ud558\ub294 css","author":"anydragon","date":"2022\ub144 06\uc6d4 15\uc77c","format":false,"excerpt":".css \/* table-responsive\uc758 \ub192\uc774\uac00 \uc9e7\uc744\ub54c dropdown-menu\uac00 \uc9e4\ub9ac\ub294 \ubb38\uc81c \ud574\uacb0 *\/ @media (max-width: 767px) { .table-responsive .dropdown-menu { position: static !important; } } \u00a0","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1928,"url":"https:\/\/anyons.net\/?p=1928","url_meta":{"origin":12,"position":2},"title":"\ud1b5\uacc4\uc6a9 \ucffc\ub9ac \uc0d8\ud50c","author":"anydragon","date":"2021\ub144 03\uc6d4 18\uc77c","format":false,"excerpt":"select year as '\ub144', month as '\uc6d4', count(*) as count from ( select YEAR(us.fd_dtcreate) as 'year', MONTH(us.fd_dtcreate) as 'month' from tb_ykfile as us where us.fd_dtCreate > '2020-08-01' and us.fd_dtCreate <= '2022-01-01' ) tb group by year, month order by year, month ; SELECT CONVERT(varCHAR(10),Dateadd(d, a.number,'2020-08-01 00:00:00'),120) AS dt ,Isnull(b.count, 0)\u2026","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/anyons.net\/?cat=96"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1799,"url":"https:\/\/anyons.net\/?p=1799","url_meta":{"origin":12,"position":3},"title":"media query Size","author":"anydragon","date":"2020\ub144 10\uc6d4 17\uc77c","format":false,"excerpt":"\ubd80\ud2b8\uc2a4\ud2b8\ub7a9\uc758 \uadf8\ub9ac\ub4dc class .col-xl- (\ucd08\ub300\ud615 \uc7a5\uce58) .col-lg- (\ub300\ud615 \uc7a5\uce58 - \ud654\uba74 \ub108\ube44\uac00 1200 px \ubbf8\ub9cc) .col-md- (\uc911\uac04 \ud06c\uae30 \uc7a5\uce58 - \ud654\uba74 \ub108\ube44\uac00 992px \ubbf8\ub9cc) .col-sm- (\uc18c\ud615 \uc7a5\uce58 - \ud654\uba74 \ub108\ube44\uac00 768px \ubbf8\ub9cc) .col- (\uc18c\ud615 \uc7a5\uce58 - \ud654\uba74 \ub108\ube44\uac00 576px \ubbf8\ub9cc) .col (\uae30\ubcf8\uac12 - \uc790\ub3d9\uc73c\ub85c \ubc18\uc751) \uae30\ubcf8 - \ub370\uc2a4\ud06c\ud0d1 @media (min-width:\u2026","rel":"","context":"&quot;Concept&quot;\uc5d0\uc11c","block_context":{"text":"Concept","link":"https:\/\/anyons.net\/?cat=95"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1784,"url":"https:\/\/anyons.net\/?p=1784","url_meta":{"origin":12,"position":4},"title":"MSSQL Table List Query","author":"anydragon","date":"2020\ub144 08\uc6d4 20\uc77c","format":false,"excerpt":"(10%) select name from sysobjects where type='U' (13%) select * from information_schema.tables (76%) select * from sys.tables","rel":"","context":"&quot;Command&quot;\uc5d0\uc11c","block_context":{"text":"Command","link":"https:\/\/anyons.net\/?cat=93"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1395,"url":"https:\/\/anyons.net\/?p=1395","url_meta":{"origin":12,"position":5},"title":"Select Insert","author":"anydragon","date":"2017\ub144 09\uc6d4 18\uc77c","format":false,"excerpt":"INSERT INTO table2 (column1, column2, column3, ...) SELECT column1, column2, column3, ... FROM table1 WHERE condition;","rel":"","context":"&quot;Command&quot;\uc5d0\uc11c","block_context":{"text":"Command","link":"https:\/\/anyons.net\/?cat=93"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/12","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12"}],"version-history":[{"count":0,"href":"https:\/\/anyons.net\/index.php?rest_route=\/wp\/v2\/posts\/12\/revisions"}],"wp:attachment":[{"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anyons.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}