{"height":"190","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fgonsuke777.hatenablog.com%2Fentry%2F20170324%2F1490332323\" title=\"SQL \u306e FETCH FIRST n ROWS\u69cb\u6587\u3067 Top n \u3084 \u540c\u30bd\u30fc\u30c8\u30ad\u30fc\u5024\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u62bd\u51fa\u3059\u308b\u3002(Oracle Database 12c) - \u306d\u3089\uff5eIT\u30a8\u30f3\u30b8\u30cb\u30a2\u96d1\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","categories":["Oracle","Database"],"description":"Oracle Database 12c \u3067\u8ffd\u52a0\u3055\u308c\u305f FETCH FIRST n ROWS\u69cb\u6587\u3092\u4f7f\u3046\u3068\u3001 Top n \u3084 \u540c\u30bd\u30fc\u30c8\u30ad\u30fc\u5024\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u62bd\u51fa\u3067\u304d\u308b\u3093\u3084\u3067\u5f61(\uff9f)(\uff9f)\u30b5\u30f3\u30d7\u30eb\u306f\u4ee5\u4e0b\u306e\u30c7\u30fc\u30bf SELECT MIN(C1) AS C1_MIN , MAX(C1) AS C1_MAX , COUNT(C1) AS C1_CNT , COUNT(DISTINCT C1) AS C1_NUM_DISTINCT FROM TBL_A; C1_MIN C1_MAX C1_CNT C1_NUM_DISTINCT ---------- ---------- ---------- ----------\u2026","type":"rich","author_url":"https://blog.hatena.ne.jp/gonsuke777/","provider_url":"https://hatena.blog","published":"2017-03-24 14:12:03","url":"https://gonsuke777.hatenablog.com/entry/20170324/1490332323","blog_title":"\u306d\u3089\uff5eIT\u30a8\u30f3\u30b8\u30cb\u30a2\u96d1\u8a18","author_name":"gonsuke777","width":"100%","version":"1.0","title":"SQL \u306e FETCH FIRST n ROWS\u69cb\u6587\u3067 Top n \u3084 \u540c\u30bd\u30fc\u30c8\u30ad\u30fc\u5024\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u62bd\u51fa\u3059\u308b\u3002(Oracle Database 12c)","blog_url":"https://gonsuke777.hatenablog.com/","image_url":null}