{"id":4590,"date":"2021-11-04T10:11:54","date_gmt":"2021-11-04T01:11:54","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4590"},"modified":"2021-11-04T10:14:11","modified_gmt":"2021-11-04T01:14:11","slug":"top-n-using-row-limiting-%ea%b8%b0%eb%8a%a5-rownum-%ea%b8%b0%eb%8a%a5-%ec%b6%94%ea%b0%80","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4590","title":{"rendered":"Top-N using Row limiting \uae30\ub2a5 ( Rownum \uae30\ub2a5 \ucd94\uac00 )"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p><strong><span style=\"font-size: large;\">Top-N using Row limiting clause<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image-1.png\"><img loading=\"lazy\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image_thumb.png?resize=640%2C263\" alt=\"image\" width=\"640\" height=\"263\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image-2.png\"><img loading=\"lazy\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image_thumb-1.png?resize=640%2C330\" alt=\"image\" width=\"640\" height=\"330\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p><a href=\"http:\/\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image-3.png\">\u00a0<\/a><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image-3.png\"><img loading=\"lazy\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image_thumb-2.png?resize=640%2C319\" alt=\"image\" width=\"640\" height=\"319\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image-4.png\"><img loading=\"lazy\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image_thumb-3.png?resize=640%2C335\" alt=\"image\" width=\"640\" height=\"335\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image-5.png\"><img loading=\"lazy\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image_thumb-4.png?resize=640%2C337\" alt=\"image\" width=\"640\" height=\"337\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image-6.png\"><img loading=\"lazy\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image_thumb-5.png?resize=640%2C344\" alt=\"image\" width=\"640\" height=\"344\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image-7.png\"><img loading=\"lazy\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image_thumb-6.png?resize=640%2C349\" alt=\"image\" width=\"640\" height=\"349\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image-8.png\"><img loading=\"lazy\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image_thumb-7.png?resize=640%2C346\" alt=\"image\" width=\"640\" height=\"346\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image-9.png\"><img loading=\"lazy\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image_thumb-8.png?resize=640%2C343\" alt=\"image\" width=\"640\" height=\"343\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image-10.png\"><img loading=\"lazy\" style=\"display: inline; background-image: none;\" title=\"image\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/2021\/11\/image_thumb-9.png?resize=640%2C340\" alt=\"image\" width=\"640\" height=\"340\" border=\"0\" data-recalc-dims=\"1\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Top-N using Row limiting clause &nbsp; &nbsp; \u00a0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<\/p>\n","protected":false},"author":1,"featured_media":2336,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[20],"tags":[74,1199,1200],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/Oracle-12c-logo-New.png?fit=499%2C302","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4590"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4590"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4590\/revisions"}],"predecessor-version":[{"id":4592,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4590\/revisions\/4592"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2336"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4590"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4590"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}