{"id":53,"date":"2012-08-20T20:38:09","date_gmt":"2012-08-20T11:38:09","guid":{"rendered":"http:\/\/leaqua.mulple.com\/?p=53"},"modified":"2018-03-15T10:38:12","modified_gmt":"2018-03-15T01:38:12","slug":"mssql-top%ec%b2%98%eb%a6%ac-%ec%a4%91%ea%b0%84%ec%9d%98-%eb%8d%b0%ec%9d%b4%ed%83%80%eb%a5%bc-%ec%96%bb%ea%b8%b0%ec%9c%84%ed%95%9c-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"https:\/\/leaqua.mulple.com\/?p=53","title":{"rendered":"mssql top\ucc98\ub9ac (\uc911\uac04\uc758 \ub370\uc774\ud0c0\ub97c \uc5bb\uae30\uc704\ud55c \ubc29\ubc95 )"},"content":{"rendered":"<pre class=\"brush: sql; gutter: false\">SELECT TOP <div class=\"fusion-fullwidth fullwidth-box hundred-percent-fullwidth non-hundred-percent-height-scrolling\"  style='background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;border-top-width:0px;border-bottom-width:0px;border-color:#eae9e9;border-top-style:solid;border-bottom-style:solid;'><div class=\"fusion-builder-row fusion-row \"><div  class=\"fusion-layout-column fusion_builder_column fusion_builder_column_1_1  fusion-one-full fusion-column-first fusion-column-last fusion-column-no-min-height 1_1\"  style='margin-top:0px;margin-bottom:0px;'>\n\t\t\t\t\t<div class=\"fusion-column-wrapper\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;\"  data-bg-url=\"\">\n\t\t\t\t\t\t[\uc5bb\uc73c\ub824\ub294 \ud589\uc758\uc218] * \r\nFROM [TABLE]\r\n WHERE [PRIMARY KEY] NOT IN \r\n( \r\n          SELECT TOP [\uc911\uac04\uc758 \uc2dc\uc791\uc704\uce58 - 1] [PRIMARY KEY] \r\n          FROM [TABLE] \r\n          WHERE [\uc870\uac74] \r\n          ORDER BY [PRIMARY KEY]\r\n )\r\n AND [\uc870\uac74] \r\nORDER BY [PRIMARY KEY]<\/pre>\n<pre class=\"lang:default decode:true brush: sql; gutter: false \" title=\"\ub370\uc774\ud130 \uc0c1\ub2e8\uc758 20\uac1c \uc911\uc5d0 \ucc98\uc74c 10\uac1c\ub97c \uc81c\uc678\ud55c 11~20\ubc88\uc9f8 \ub370\uc774\ud130\ub97c \uac00\uc838\uc628\ub2e4\">select top 20  * \r\nfrom  datatable\r\nwhere idfield not in (select top 8 idfield from authors  order by idfield)\r\norder by idfield<\/pre>\n<p>&nbsp;<div class=\"fusion-clearfix\"><\/div>\n\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div><\/div><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT TOP <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[6],"tags":[],"_links":{"self":[{"href":"https:\/\/leaqua.mulple.com\/index.php?rest_route=\/wp\/v2\/posts\/53"}],"collection":[{"href":"https:\/\/leaqua.mulple.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/leaqua.mulple.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/leaqua.mulple.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/leaqua.mulple.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=53"}],"version-history":[{"count":7,"href":"https:\/\/leaqua.mulple.com\/index.php?rest_route=\/wp\/v2\/posts\/53\/revisions"}],"predecessor-version":[{"id":1399,"href":"https:\/\/leaqua.mulple.com\/index.php?rest_route=\/wp\/v2\/posts\/53\/revisions\/1399"}],"wp:attachment":[{"href":"https:\/\/leaqua.mulple.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=53"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/leaqua.mulple.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=53"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/leaqua.mulple.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=53"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}