{"url":"https://dk521123.hatenablog.com/entry/2018/04/01/154134","type":"rich","blog_url":"https://dk521123.hatenablog.com/","published":"2018-04-01 15:41:34","width":"100%","provider_name":"Hatena Blog","height":"190","title":"\u3010SQL\u3011 LIMIT \uff5e \u51fa\u529b\u3059\u308b\u884c\u6570\u3092\u5236\u9650\u3059\u308b \uff5e","categories":["MySQL","PostgreSQL","Snowflake"],"blog_title":"\u30d7\u30ed\u30b0\u30e9\u30e0 \u306e\u8d85\u500b\u4eba\u7684\u306a\u30e1\u30e2","author_url":"https://blog.hatena.ne.jp/dk521123/","version":"1.0","author_name":"dk521123","provider_url":"https://hatena.blog","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdk521123.hatenablog.com%2Fentry%2F2018%2F04%2F01%2F154134\" title=\"\u3010SQL\u3011 LIMIT \uff5e \u51fa\u529b\u3059\u308b\u884c\u6570\u3092\u5236\u9650\u3059\u308b \uff5e - \u30d7\u30ed\u30b0\u30e9\u30e0 \u306e\u8d85\u500b\u4eba\u7684\u306a\u30e1\u30e2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"\u3010\uff11\u3011LIMIT * \u51fa\u529b\u3059\u308b\u884c\u6570\u3092\u5236\u9650\u3059\u308b * PostgreSQL \u3084 Snowflake \u3067\u3082\u4f7f\u3048\u308b\u307f\u305f\u3044 \u3010\uff12\u3011\u69cb\u6587 SELECT [\u9805\u76ee1] (, ...) FROM [\u30c6\u30fc\u30d6\u30eb\u540d] LIMIT ([\u958b\u59cb\u4f4d\u7f6e\uff08\u884c\u6570],) \u53d6\u5f97\u3059\u308b\u884c\u6570 \u3010\uff13\u3011\u30b5\u30f3\u30d7\u30eb SELECT * FROM user LIMIT 5 \uff11\uff09\u51fa\u529b\u7d50\u679c \"1\" \"1\" \"Kim\" \"1983-12-11\" \"2\" \"1\" \"Mike\" \"2018-02-02\" \"3\" \"1\" \"Sam\" \"1922-12-30\" \"4\" \"1\" \"Smith\" \"2006-07-14\" \"5\" \"1\" \"Nancy\" \"2003-08\u2026"}