{"id":15,"date":"2023-07-27T20:18:01","date_gmt":"2023-07-27T11:18:01","guid":{"rendered":"https:\/\/sejiwonad.mycafe24.com\/?p=15"},"modified":"2023-07-27T20:18:01","modified_gmt":"2023-07-27T11:18:01","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-listagg%ec%99%80-%ea%b0%99%ec%9d%80-mysql-%ed%95%a8%ec%88%98-group_concat","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=15","title":{"rendered":"\uc624\ub77c\ud074 LISTAGG\uc640 \uac19\uc740 MySQL \ud568\uc218 GROUP_CONCAT"},"content":{"rendered":"\n<p>\uc624\ub77c\ud074 LISTAGG\uc640 \uac19\uc774 MySQL\uc5d0\uc11c \uc0ac\uc6a9\ud558\uace0 \uc2f6\uc744 \ub54c \uc0ac\uc6a9\ud558\ub294 \ud568\uc218\ub294 \uc544\ub798\uc640 \uac19\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT COL_ID\n      ,COL_NM \n      ,GROUP_CONCAT( tbl_id order by tbl_id) as TBL_ID\n      ,GROUP_CONCAT( tbl_nm order by tbl_id) as TBL_NM\n      ,COUNT(*) AS CNT\n  FROM mb_tblinfo\n where col_id &lt;&gt; ''\ngroup by COL_ID\n      ,COL_NM   \norder by 1,2   <\/pre>\n\n\n\n<p>GROUP_CONCAT\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc624\ub77c\ud074\uc758 LISTAGG\ucc98\ub7fc \ud65c\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc624\ub77c\ud074 LISTAGG\uc640 \uac19\uc774 MySQL\uc5d0\uc11c \uc0ac\uc6a9\ud558\uace0 \uc2f6\uc744 \ub54c \uc0ac\uc6a9\ud558\ub294 \ud568\uc218\ub294 \uc544\ub798\uc640 \uac19\ub2e4. SELECT COL_ID ,COL_NM ,GROUP_CONCAT( tbl_id order by tbl_id) as TBL_ID ,GROUP_CONCAT( tbl_nm order by tbl_id) as TBL_NM ,COUNT(*) AS CNT FROM mb_tblinfo where col_id &lt;&gt; &#8221; group by COL_ID ,COL_NM order by 1,2 GROUP_CONCAT\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc624\ub77c\ud074\uc758 LISTAGG\ucc98\ub7fc \ud65c\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/15"}],"collection":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/15\/revisions"}],"predecessor-version":[{"id":17,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/15\/revisions\/17"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}