{"id":1957,"date":"2013-02-04T19:00:08","date_gmt":"2013-02-04T10:00:08","guid":{"rendered":"http:\/\/auctionpro.co.kr\/?p=1957"},"modified":"2017-02-27T09:42:47","modified_gmt":"2017-02-27T00:42:47","slug":"mysql-group-by-distinct-count-%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%9c-%ea%b2%b9%ec%b9%98%ec%a7%80-%ec%95%8a%eb%8a%94%ea%b2%83%ec%9d%98-%ea%b0%9c%ec%88%98","status":"publish","type":"post","link":"https:\/\/www.auctionpro.co.kr\/?p=1957","title":{"rendered":"MYSQL] group by, distinct, count \ub97c \uc774\uc6a9\ud55c \uacb9\uce58\uc9c0 \uc54a\ub294\uac83\uc758 \uac1c\uc218"},"content":{"rendered":"<p>select name, count(name) from testbl group by name;<br \/>\nselect count(distinct name) from testbl<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>select name, count(name) from testbl group by name; select count(distinct name) from testbl<\/p>\n<\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[16],"tags":[],"class_list":["post-1957","post","type-post","status-publish","format-standard","hentry","category-mssql-server"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1957"}],"version-history":[{"count":0,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/1957\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auctionpro.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}