{"id":3968,"date":"2017-08-25T01:09:33","date_gmt":"2017-08-25T08:09:33","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=3968"},"modified":"2025-06-13T17:23:17","modified_gmt":"2025-06-14T00:23:17","slug":"paging-data-queries-with-n1ql","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/paging-data-queries-with-n1ql\/","title":{"rendered":"N1QL\uc744 \uc0ac\uc6a9\ud55c \ub370\uc774\ud130 \ucffc\ub9ac \ud398\uc774\uc9d5"},"content":{"rendered":"<p><em>M. David Allen\uc740 10\ub144 \ub118\uac8c \uac70\uc758 \ubaa8\ub4e0 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\uc640 \ub2e4\uc591\ud55c \uc720\ud615\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc744 \ub2e4\ub904\uc628 \ud480\uc2a4\ud0dd \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc5d4\uc9c0\ub2c8\uc5b4\uc774\uc790 \uae30\uc5c5\uac00\uc785\ub2c8\ub2e4.  \uc774\uc804\uc5d0\ub294 \uae08\uc735, \uc758\ub8cc, \uc815\ubd80 \ub4f1 \ub2e4\uc591\ud55c \uc0b0\uc5c5 \ubd84\uc57c\uc5d0\uc11c \uc77c\ud588\uc73c\uba70, \uc8fc\ub85c \ub300\uaddc\ubaa8 \ub370\uc774\ud130 \ud1b5\ud569 \ubb38\uc81c, \uc751\uc6a9 \uc5f0\uad6c \uc804\ud658, \uc2e0\uae30\uc220 \ud601\uc2e0\uc5d0 \uc911\uc810\uc744 \ub450\uc5c8\uc2b5\ub2c8\ub2e4.  \uadf8\ub294 \ubc84\uc9c0\ub2c8\uc544 \ucee4\uba3c\uc6f0\uc2a4 \ub300\ud559\uad50\uc5d0\uc11c \uc11d\uc0ac \ud559\uc704\ub97c \ubc1b\uc558\uc9c0\ub9cc, \uc815\uaddc \uad50\uc721\uc744 \ub5a0\ub09c \uc774\ud6c4\uc5d0\ub3c4 \uc5ec\uc804\ud788 \uae30\uc220\uc744 \uacf5\ubd80\ud558\ub294 \ud559\uc0dd\uc73c\ub85c \ub0a8\uc544 \uc788\uc2b5\ub2c8\ub2e4.<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5662\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2017\/09\/Simple-Small-Headshot-450x300-compressed-300x200.png\" alt=\"\" width=\"410\" height=\"273\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/Simple-Small-Headshot-450x300-compressed-300x200.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/Simple-Small-Headshot-450x300-compressed-400x267.png 400w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/Simple-Small-Headshot-450x300-compressed.png 450w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/Simple-Small-Headshot-450x300-compressed-20x13.png 20w\" sizes=\"auto, (max-width: 410px) 100vw, 410px\" \/><\/p>\n<h2>\uc124\uc815<\/h2>\n<p>\uc774 \ud29c\ud1a0\ub9ac\uc5bc\uc5d0\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 <u><a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/4.1\/developer-guide\/sample-bucket-beer.html\" target=\"_blank\" rel=\"noopener noreferrer\">\ub9e5\uc8fc \uc0d8\ud50c \ub370\uc774\ud130 \uc138\ud2b8<\/a><\/u>\u00a0\ub97c \uc0ac\uc6a9\ud558\uba74 \uc27d\uac8c \ub530\ub77c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.   \uc544\uc9c1 Couchbase\uac00 \uc124\uce58\ub418\uc5b4 \uc788\uc9c0 \uc54a\ub2e4\uba74 \ub3c4\ucee4\uc640 <u><a href=\"https:\/\/hub.docker.com\/_\/couchbase\/\" target=\"_blank\" rel=\"noopener noreferrer\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ub3c4\ucee4 \uc774\ubbf8\uc9c0 \ud398\uc774\uc9c0\uc758 \uac04\ub2e8\ud55c \uc9c0\uce68\uc744 \ub530\ub974\uc138\uc694.<\/a><\/u>\u00a0\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud14c\uc2a4\ud2b8\uc6a9 Couchbase \uc778\uc2a4\ud134\uc2a4\ub97c \ube60\ub974\uac8c \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.    Couchbase\uac00 \uc124\uce58\ub41c \uc0c1\ud0dc\uc5d0\uc11c docker run -d -name db -p 8091-8094:8091-8094 -p 11210:11210 Couchbase \uba85\ub839\uc744 \uc2e4\ud589\ud558\uae30\ub9cc \ud558\uba74 \uc2dc\uc791\ub429\ub2c8\ub2e4.   \ud574\ub2f9 \ud398\uc774\uc9c0\uc5d0 \uc124\uba85\ub41c \uba87 \uac00\uc9c0 \uc124\uc815 \ud504\ub86c\ud504\ud2b8\ub97c \ub530\ub974\uace0 \ub098\uba74 \ub370\uc774\ud130\ub97c \uc0ac\uc6a9\ud560 \uc900\ube44\uac00 \ub41c \uac83\uc785\ub2c8\ub2e4.<\/p>\n<h2>\uc0ac\uc6a9 \uc0ac\ub840 - \ud398\uc774\uc9d5\uc774\ub780 \ubb34\uc5c7\uc774\uba70 \uc65c \ud398\uc774\uc9d5\uc744 \ud574\uc57c \ud558\ub098\uc694?<\/h2>\n<p>\uac00\uc0c1\uc758 \ud504\ub7f0\ud2b8\uc5d4\ub4dc \ub9e5\uc8fc \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \uc0ac\uc6a9\uc790\uc5d0\uac8c \ub9e5\uc8fc \ud45c\ub97c \ubcf4\uc5ec\uc8fc\uace0 \uac01 \ub9e5\uc8fc\ub97c \ud3c9\uac00\ud558\ub3c4\ub85d \ud558\ub824\ub294 \ub9e4\uc6b0 \uc77c\ubc18\uc801\uc778 \uc694\uad6c \uc0ac\ud56d\uc744 \uace0\ub824\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.  \ubb38\uc81c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 5,000\uac1c\uac00 \ub118\ub294 \ub9e5\uc8fc\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.  \ub9e4\ubc88 \uc804\uccb4 \ub370\uc774\ud130 \uc138\ud2b8\ub97c \ube0c\ub77c\uc6b0\uc800\ub85c \uc804\uc1a1\ud558\ub294 \uac83\uc740 \ub0ad\ube44\uc774\uba70 \uc6f9 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ud398\uc774\uc9c0 \ub85c\ub529 \uc18d\ub3c4\uac00 \ub9e4\uc6b0 \ub290\ub824\uc9c8 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc0ac\uc6a9\uc790\uc5d0\uac8c \ucc98\uc74c 10\uac1c\uc758 \ub9e5\uc8fc\ub9cc \ud45c\uc2dc\ud558\ub294 \uac83\uc774 \ud6e8\uc52c \ub354 \uc88b\uc2b5\ub2c8\ub2e4.  \uadf8\ub7f0 \ub2e4\uc74c '\ub2e4\uc74c' \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc5ec \ub2e4\uc74c \ud398\uc774\uc9c0\ub85c \uc774\ub3d9\ud558\uac70\ub098 \ubb34\ud55c \uc2a4\ud06c\ub864 \ud50c\ub7ec\uadf8\uc778\uc744 \uc0ac\uc6a9\ud558\uba74 \ub354 \uc88b\uc2b5\ub2c8\ub2e4(\uc608 <u><a href=\"https:\/\/sroze.github.io\/ngInfiniteScroll\/\" target=\"_blank\" rel=\"noopener noreferrer\">ngInfiniteScroll<\/a><\/u>\u00a0\uac01\uc9c4 \ub610\ub294<u><a href=\"https:\/\/github.com\/seatgeek\/react-infinite\" target=\"_blank\" rel=\"noopener noreferrer\">\u00a0\ub9ac\uc561\ud2b8-\uc778\ud53c\ub2c8\ud2b8<\/a><\/u>\u00a0\uc758 \uacbd\uc6b0) \uc0ac\uc6a9\uc790\uc5d0\uac8c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ub808\ucf54\ub4dc\ub97c \uc810\uc9c4\uc801\uc73c\ub85c \ub354 \ub9ce\uc774 \ud45c\uc2dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h2>\ucf54\ub4dc\ub97c \ubcf4\uc5ec\uc8fc\uc138\uc694!<\/h2>\n<pre class=\"lang:default decode:true\">SELECT name, category, abv from `beer-sample`\r\n\r\nWHERE brewery_id is not missing\r\n\r\nORDER BY name\r\n\r\nOFFSET 0\r\n\r\nLIMIT 10;<\/pre>\n<p>\uadf8\ub7ec\uba74 \uc608\uc0c1\ub418\ub294 \ub370\uc774\ud130\uac00 \ubc18\ud658\ub429\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default decode:true\">[\r\n\r\n\u00a0 {\r\n\r\n\u00a0 \u00a0 \"abv\": 0,\r\n\r\n\u00a0 \u00a0 \"category\": \"North American Lager\",\r\n\r\n\u00a0 \u00a0 \"name\": \"#17 Cream Ale\"\r\n\r\n\u00a0 },\r\n\r\n\u00a0 {\r\n\r\n\u00a0 \u00a0 \"abv\": 0,\r\n\r\n\u00a0 \u00a0 \"name\": \"#40 Golden Lager\"\r\n\r\n\u00a0 },\r\n\r\n\u00a0 {\r\n\r\n\u00a0 \u00a0 \"abv\": 0,\r\n\r\n\u00a0 \u00a0 \"category\": \"Other Style\",\r\n\r\n\u00a0 \u00a0 \"name\": \"#42 Cream Ale\"\r\n\r\n\u00a0 },\r\n\r\n\u00a0 \/* (...) *\/\r\n\r\n<\/pre>\n<p>\ub450 \ubc88\uc9f8 \ud398\uc774\uc9c0\uc758 \uacb0\uacfc\ub97c \uc5bb\uc73c\ub824\uba74 OFFSET\uc5d0 LIMIT\ub9cc \ucd94\uac00\ud558\uba74 \ub429\ub2c8\ub2e4.    \uc608\ub97c \ub4e4\uc5b4 OFFSET 10 LIMIT 10\uc740 \ub450 \ubc88\uc9f8 \ud398\uc774\uc9c0\uac00 \ub429\ub2c8\ub2e4.   \uc774\ub97c \uc77c\ubc18\ud654\ud558\uae30 \uc704\ud574 n\ubc88\uc9f8 \ud398\uc774\uc9c0\uc5d0 \ub3c4\ub2ec\ud558\uae30 \uc704\ud574 OFFSET\uc73c\ub85c \uba87 \uac1c\uc758 \ub808\ucf54\ub4dc\ub97c \uac74\ub108\ub6f0\uc5b4\uc57c \ud560\uae4c\uc694?    \ud56d\uc0c1 n * \ud398\uc774\uc9c0 \ud06c\uae30\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc774 \uac04\ub2e8\ud55c \uc218\uc2dd\uc744 \uc0ac\uc6a9\ud558\uba74 \ubaa8\ub4e0 \uc2dc\ub098\ub9ac\uc624\uc5d0 \uc77c\ubc18\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \ud55c \ubc88\uc5d0 20\uac1c\uc758 \uacb0\uacfc\ub97c \ud45c\uc2dc\ud558\uace0 \uc2f6\uc740\ub370 \uc0ac\uc6a9\uc790\uac00 11\ubc88\uc9f8 \ud398\uc774\uc9c0\ub85c \ubc14\ub85c \uc774\ub3d9\ud558\uae30\ub97c \uc6d0\ud55c\ub2e4\uba74 \uc5b4\ub5bb\uac8c \ud574\uc57c \ud560\uae4c\uc694?   \ubb38\uc81c\uc5c6\uc2b5\ub2c8\ub2e4. LIMIT 20 OFFSET 20 * 11\uc774\uba74 \ub429\ub2c8\ub2e4.   \uadf8\ub7ec\uba74 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc5d4\ub4dc\ud3ec\uc778\ud2b8\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uac80\uc0c9\ud558\ub4e0, \ub2e8\uc21c\ud788 \ub9e5\uc8fc\ub97c \uc774\ub984\uc73c\ub85c \ub098\uc5f4\ud558\ub4e0 \ub9e4\ubc88 \ub611\uac19\uc740 \ucffc\ub9ac \ub85c\uc9c1\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \ucffc\ub9ac\uac00 \uc544\ubb34\ub9ac \ubcf5\uc7a1\ud558\ub354\ub77c\ub3c4 LIMIT\uc640 OFFSET\ub9cc \uc870\uc815\ud558\uba74 \ubaa8\ub450 \uac19\uc740 \ud398\uc774\uc9c0\uc5d0 \uc788\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<h2>\uc5b4\ub5bb\uac8c \uc791\ub3d9\ud558\ub098\uc694?<\/h2>\n<p>\uc5ec\uae30\uc11c \ub9c8\ubc95\uc740 \uc138 \uac1c\uc758 N1QL \uc808\uc758 \uc870\ud569\uc785\ub2c8\ub2e4: \u00a0<strong>LIMIT<\/strong>, <strong>\uc624\ud504\uc14b<\/strong>\ubc0f <strong>\uc8fc\ubb38 \uae30\uc900<\/strong>.   \uc791\uc5c5\uc744 \uc644\ub8cc\ud558\ub294 \ub370 \ubaa8\ub450 \ud544\uc694\ud558\ubbc0\ub85c \uac01\uac01\uc5d0 \ub300\ud574 \uac04\ub2e8\ud788 \uc0b4\ud3b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li><strong><a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/current\/n1ql\/n1ql-language-reference\/limit.html\" target=\"_blank\" rel=\"noopener noreferrer\">LIMIT<\/a><\/strong>\u00a0\ub294 \ub9d0 \uadf8\ub300\ub85c \uc791\ub3d9\ud569\ub2c8\ub2e4. Couchbase\uac00 \ubc18\ud658\ud560 \ub808\ucf54\ub4dc \uc218\ub97c \uc81c\ud55c\ud558\uace0 \ud398\uc774\uc9c0 \ud06c\uae30\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uac15\uc81c\ud569\ub2c8\ub2e4(\ud55c \ubc88\uc5d0 10\uac1c\uc758 \ub9e5\uc8fc\ub9cc \ubc18\ud658\ud558\uace0 5,000\uac1c\ub294 \ubc18\ud658\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4).<\/li>\n<li><strong><a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/current\/n1ql\/n1ql-language-reference\/offset.html\" target=\"_blank\" rel=\"noopener noreferrer\">\uc624\ud504\uc14b<\/a><\/strong>\u00a0\ub294 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uac00 \ubb38\uc11c \ubc18\ud658\uc744 \uc2dc\uc791\ud558\uae30 \uc804\uc5d0 \uac74\ub108\ub6f8 \ub808\ucf54\ub4dc \uc218\ub97c \uc54c\ub824\uc90d\ub2c8\ub2e4. SQL\uc5d0 \uc775\uc219\ud558\ub2e4\uba74 SQL\uc758 SKIP\ucc98\ub7fc \uc791\ub3d9\ud569\ub2c8\ub2e4. OFFSET \uc808\uc740 \uc804\uccb4 \ub370\uc774\ud130 \uc9d1\ud569\uc744 \ud55c \ubc88\uc5d0 \ud55c \uccad\ud06c\uc529 \uc55e\uc73c\ub85c \uc774\ub3d9\ud558\ub294 \ubc29\uc2dd\uc785\ub2c8\ub2e4.<\/li>\n<li><strong><a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/current\/n1ql\/n1ql-language-reference\/orderby.html\" target=\"_blank\" rel=\"noopener noreferrer\">\uc8fc\ubb38 \uae30\uc900<\/a><\/strong>\u00a0\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ubc18\ud658\ub418\ub294 \ud2b9\uc815 \uc21c\uc11c\ub97c \ubcf4\uc7a5\ud569\ub2c8\ub2e4. \uc774\ub294 \uc911\uc694\ud55c\ub370, \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\ub294 \uc0ac\uc6a9\uc790\uac00 \uc694\uccad\ud558\uc9c0 \uc54a\ub294 \ud55c \uacb0\uacfc\uc758 \ud2b9\uc815 \uc21c\uc11c\ub97c \ubcf4\uc7a5\ud558\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.  \uc774\uc804 \ucffc\ub9ac\uc5d0\uc11c\ub294 \uc774\ub984\uc73c\ub85c \uc8fc\ubb38\ud560 \ub54c #17 \ud06c\ub9bc \uc5d0\uc77c\uc774 \uccab \ubc88\uc9f8 \uacb0\uacfc\ub85c \ub098\ud0c0\ub0ac\uc2b5\ub2c8\ub2e4. ORDER BY\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc558\ub2e4\uba74 #17 \ud06c\ub9bc \uc5d0\uc77c\uc774 \uc138\ud2b8\uc758 \uc5b4\ub290 \uc704\uce58\uc5d0 \ud45c\uc2dc\ub420\uc9c0 \uc608\uce21\ud560 \uc218 \uc5c6\uc5c8\uc744 \uac83\uc774\uba70, \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uac00 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\ub294 \ubc29\uc2dd\uc5d0 \ub530\ub77c \uc5ec\ub7ec \ud398\uc774\uc9c0\uc5d0 \ud45c\uc2dc\ub420 \uc218\ub3c4 \uc788\uc5c8\uc744 \uac83\uc785\ub2c8\ub2e4!<\/li>\n<\/ul>\n<p>\uac04\ub2e8\ud788 \ub9d0\ud574, \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uac00 \uc774\ub984\ubcc4\ub85c \uc8fc\ubb38\ub41c \ubaa8\ub4e0 \ub9e5\uc8fc\uc758 \ubaa9\ub85d\uc744 \uc791\uc131\ud55c\ub2e4\uace0 \uc0c1\uc0c1\ud574 \ubcf4\uc138\uc694(ORDER BY).  \ud398\uc774\uc9c0 \ub9e4\uae40\uc740 \uadf8 \uc911 10\uac1c\uc529 \uc77c\uad04 \ucc98\ub9ac\ud558\ub294 \uac83\uc785\ub2c8\ub2e4(LIMIT 10).   \uadf8\ub7f0 \ub2e4\uc74c \uac01 \ud398\uc774\uc9c0\ub294 \uc8fc\ubb38\ud55c \uc804\uccb4 \ubaa9\ub85d\uc744 \uac74\ub108\ub6f0\uace0 \ub2e4\uc74c \ud398\uc774\uc9c0\uc758 \uc2dc\uc791 \uc9c0\uc810\uc73c\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4(OFFSET).<\/p>\n<h2>\uc9c1\uc811 \uc124\uba85\ud558\uc138\uc694, \uce74\uc6b0\uce58\ubca0\uc774\uc2a4.<\/h2>\n<p>\ub9c8\uc9c0\ub9c9 \uc608\ub85c, \ub2e4\ub978 N1QL \ucffc\ub9ac\uc640 \ub9c8\ucc2c\uac00\uc9c0\ub85c \ucffc\ub9ac \uc55e\uc5d0 \"\uc124\uba85\"\uc744 \ub123\ub294 \uac83\ub9cc\uc73c\ub85c\ub3c4 \uc791\ub3d9 \ubc29\uc2dd\uc5d0 \ub300\ud55c \ub9ce\uc740 \uc778\uc0ac\uc774\ud2b8\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \uc774\ub807\uac8c \ud558\uba74 Couchbase\uac00 \ubb34\uc5c7\uc744 \ud560 \uacc4\ud68d\uc778\uc9c0 \uc54c\ub824\uc90d\ub2c8\ub2e4.<\/p>\n<pre class=\"lang:default decode:true\">EXPLAIN SELECT name, category, abv from `beer-sample`\r\n\r\nWHERE brewery_id is not missing\r\n\r\nORDER BY name\r\n\r\nOFFSET 0\r\n\r\nLIMIT 10;\r\n\r\n<\/pre>\n<p>(\uc774 \ucffc\ub9ac\ub97c \uc9c1\uc811 \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694!) \ucd9c\ub825\uc740 \ub2e4\uc18c \uae38\uae30 \ub54c\ubb38\uc5d0 \uc5ec\uae30\uc5d0 \ubd99\uc5ec\ub123\uc9c0 \uc54a\uace0, \uc774 \ucffc\ub9ac\ub85c Couchbase\uac00 \uc218\ud589\ud558\ub294 \uc791\uc5c5\uc744 \uc694\uc57d\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<ol>\n<li>\uba3c\uc800 \ub9e5\uc8fc \uc0d8\ud50c \ubc84\ud0b7\uc744 1\ucc28 \uc2a4\uce94\ud558\uace0 \ubb38\uc11c\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/li>\n<li>\ub3d9\uc2dc\uc5d0 \ub2e4\uc74c\uc744 \ud544\ud130\ub9c1\ud569\ub2c8\ub2e4:\n<ol>\n<li>brewery_id\uac00 \uc788\ub294 \ub808\ucf54\ub4dc(\uc774\ub294 \ub808\ucf54\ub4dc\uac00 \ub9e5\uc8fc \ubb38\uc11c\uac00 \uc544\ub2c8\ub77c \ub9e5\uc8fc\uc784\uc744 \uc54c\ub824\uc90d\ub2c8\ub2e4)<\/li>\n<li>\uc774\ub984, \uce74\ud14c\uace0\ub9ac \ubc0f \uad11\uace0\ube44 \uc18d\uc131(\uc6b0\ub9ac\uac00 \uc694\uccad\ud55c \uac83)\uc744 \ud22c\uc601\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<\/li>\n<li>\uadf8\ub7f0 \ub2e4\uc74c \uc774\ub984\ubcc4\ub85c \uacb0\uacfc\ub97c \uc815\ub82c\ud569\ub2c8\ub2e4.<\/li>\n<li>\ub2e4\uc74c\uc5d0 \uc624\ud504\uc14b\uc774 \uc801\uc6a9\ub418\uc5b4 \uccab \ubc88\uc9f8 X \ub808\ucf54\ub4dc\ub97c \uac74\ub108\ub6f0\uace0 \uc804\ud600 \ubc18\ud658\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\ub9c8\uc9c0\ub9c9\uc73c\ub85c, \ub2e4\uc74c n\uac1c\uc758 \ub808\ucf54\ub4dc\ub97c \uc77d\uace0 \uadf8 \uc774\ud6c4\uc758 \ub808\ucf54\ub4dc\ub294 \ubaa8\ub450 \ubb34\uc2dc\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c LIMIT\ub97c \uc801\uc6a9\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<h2>\uc5b8\uc81c \ub05d\ub098\uc694?<\/h2>\n<p>\ud55c \ubc88\uc5d0 \ud55c \ud398\uc774\uc9c0\uc529 \ub370\uc774\ud130\ub97c \uc774\ub3d9\ud558\ub294 \uacbd\uc6b0, \uc5b8\uc81c \uba48\ucdb0\uc57c \ud558\ub294\uc9c0\ub3c4 \uc54c\uc544\uc57c \ud569\ub2c8\ub2e4.  \uc5ec\uae30\uc5d0\ub294 \ub450 \uac00\uc9c0 \uc811\uadfc \ubc29\uc2dd\uc774 \uc788\ub294\ub370, \ud55c \uac00\uc9c0 \ubc29\ubc95\uc740 \ud398\uc774\uc9c0\ub97c \ubb34\ud55c\uc815 \uacc4\uc18d \uc9c4\ud589\ud558\uba74 \uacb0\uad6d \ub370\uc774\ud130\uac00 \ubd80\uc871\ud574\uc9d1\ub2c8\ub2e4.   \ubc18\uba74\uc5d0 \uba87 \uac1c\uc758 \ud398\uc774\uc9c0\uac00 \uc788\ub294\uc9c0 \ubbf8\ub9ac \uacc4\uc0b0\ud55c \ub2e4\uc74c \uadf8 \uc218\uc5d0 \ub3c4\ub2ec\ud560 \ub54c\uae4c\uc9c0 \ubc18\ubcf5\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uadf8\ub7ec\ud55c \ubb38\uc11c \uc138\ud2b8\uac00 \uc5c6\ub2e4\ub294 \uac83\uc744 \uc798 \uc54c\uba74\uc11c 1,000\uac1c\uc758 \uacb0\uacfc \uc911 7\ubc88\uc9f8 \ud398\uc774\uc9c0\ub97c \uc694\uccad\ud558\uba74 \uc5b4\ub5bb\uac8c \ub420\uae4c\uc694?<\/p>\n<pre class=\"lang:default decode:true\">SELECT name, category, abv from `beer-sample`\r\n\r\nWHERE brewery_id is not missing\r\n\r\nORDER BY name\r\n\r\nOFFSET 7 * 1000\r\n\r\nLIMIT 1000;\r\n\r\n<\/pre>\n<p>\ub05d\uc744 \uc9c0\ub098\uce58\uba74 \ube48 \ubc30\uc5f4\uc774 \ub098\uc624\ub2c8 \uac71\uc815\ud558\uc9c0 \ub9c8\uc138\uc694.<\/p>\n<pre class=\"lang:default decode:true\">{\r\n\r\n\u00a0 \"results\": [],\r\n\r\n\u00a0 \"metrics\": {\r\n\r\n\u00a0 \u00a0 \"elapsedTime\": \"465.446327ms\",\r\n\r\n\u00a0 \u00a0 \"executionTime\": \"465.384101ms\",\r\n\r\n\u00a0 \u00a0 \"resultCount\": 0,\r\n\r\n\u00a0 \u00a0 \"resultSize\": 0,\r\n\r\n\u00a0 \u00a0 \"sortCount\": 5891\r\n\r\n\u00a0 }\r\n\r\n}\r\n\r\n<\/pre>\n<p>\ucc38\uace0\ub85c, \ube48 \ubc30\uc5f4\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \ub9d0\ub3c4 \uc548 \ub418\ub294 \uc694\uccad\uc744 \ud558\uba74 \uc5bb\uc744 \uc218 \uc788\ub294 \uacb0\uacfc\uc774\uae30\ub3c4 \ud569\ub2c8\ub2e4:<\/p>\n<pre class=\"lang:default decode:true\">SELECT name, category, abv from `beer-sample`\r\n\r\nWHERE brewery_id is not missing\r\n\r\nORDER BY name\r\n\r\nOFFSET -5\r\n\r\nLIMIT -10;\r\n\r\n<\/pre>\n<p>\uc7a0\uae50....\uc653?!?!  \uc774 \ucffc\ub9ac\ub294 \ucd9c\ub825 \uc138\ud2b8\uc758 \uc2dc\uc791 \uc804\uc5d0 5\uac1c\uc758 \ub808\ucf54\ub4dc\ub97c \uc2dc\uc791\ud558\uace0 -10\uac1c \uc774\ud558\uc758 \ub808\ucf54\ub4dc\ub97c \ubc18\ud658\ud558\ub3c4\ub85d \uc694\uccad\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.  \uc2dc\uc791 \uc804 5\uac1c\uc758 \ub808\ucf54\ub4dc\ub294 \uc544\ubb34\uac83\ub3c4 \uc544\ub2d9\ub2c8\ub2e4.  \uadf8\ub9ac\uace0 -10\uac1c \uc774\ud558\uc758 \ub808\ucf54\ub4dc\ub294 \uc544\ubb34\uac83\ub3c4 \uc544\ub2d9\ub2c8\ub2e4.   \uadf8\ub798\uc11c \ub2f9\uc2e0\uc740....nothing\uc744 \uc5bb\uc2b5\ub2c8\ub2e4!<\/p>\n<p>\uc774 \ub3d9\uc791\uc740 \ub9e4\uc6b0 \ud3b8\ub9ac\ud558\uba70, \ub808\ucf54\ub4dc\uac00 \ubd80\uc871\ud560 \ub54c \uba85\ud655\ud558\uace0 \ub2e4\ub978 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uacc4\uce35\uc758 \ub2e4\ub978 \ub9ce\uc740 \uac00\uc815\uacfc\ub3c4 \uc798 \uc5b4\uc6b8\ub9bd\ub2c8\ub2e4. \ud398\uc774\uc9d5\uc744 \uc9c0\uc6d0\ud558\ub294 REST API\ub97c \uc0ac\uc6a9\ud574 \ubcf8 \uc801\uc774 \uc788\ub2e4\uba74 \uc77c\ubc18\uc801\uc73c\ub85c \uc774\ub7ec\ud55c \ubc29\uc2dd\uc73c\ub85c \uc791\ub3d9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c\uacfc \uac19\uc740 REST API \uc5d4\ub4dc\ud3ec\uc778\ud2b8\ub97c \uc27d\uac8c \uc0c1\uc0c1\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4(https:\/\/cool-app.com\/beers?limit=10&amp;page=6000).   \ubc31\uc5d4\ub4dc\uc5d0 \uc774\ub7ec\ud55c \uc5d4\ub4dc\ud3ec\uc778\ud2b8\ub97c \uc791\uc131\ud588\ub2e4\uba74 \ud574\ub2f9 N1QL \ucffc\ub9ac\uac00 \uc5b4\ub5bb\uac8c \uc0dd\uc131\ub418\ub294\uc9c0 \uc27d\uac8c \uc54c \uc218 \uc788\uc73c\uba70, \uc0ac\uc6a9\uc790\uac00 \uc774\uc0c1\ud55c \ud398\uc774\uc9c0 \ubc88\ud638\ub97c \uc81c\uacf5\ud558\ub354\ub77c\ub3c4 \uc5d4\ub4dc\ud3ec\uc778\ud2b8\uac00 \uc62c\ubc14\ub978 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<h2>\ud558\uc9c0\ub9cc \uba87 \ud398\uc774\uc9c0\uac00 \ub098\uc62c\uc9c0 \ubbf8\ub9ac \uc54c\uace0 \uc2f6\ub2e4\uba74 \uc5b4\ub5bb\uac8c \ud574\uc57c \ud558\ub098\uc694?<\/h2>\n<p>\uc774\uac83\ub3c4 \uac04\ub2e8\ud569\ub2c8\ub2e4.  \uac01 \ud398\uc774\uc9c0\uc5d0 n\uac1c\uc758 \ub808\ucf54\ub4dc\uac00 \uc788\uace0 \ucd1d \ub808\ucf54\ub4dc \uc218\ub97c \uc54c\uace0 \uc788\ub2e4\uba74 \ucd1d\uacc4\ub97c n\uc73c\ub85c \ub098\ub204\uace0 \uadf8 \uc218\uc758 \uc0c1\ud55c\uc744 \uad6c\ud558\uba74 Couchbase\uc5d0 \uc5bc\ub9c8\ub098 \ub9ce\uc740 \uc7a0\uc7ac\uc801 \ud398\uc774\uc9c0\uac00 \uc788\ub294\uc9c0 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"lang:default decode:true\">SELECT CEIL(count(*) \/ 10) from `beer-sample`\r\n\r\nWHERE brewery_id is not missing\r\n\r\n<\/pre>\n<p>\uc774\ub807\uac8c \ud558\uba74 \ub0b4 \ub85c\uceec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c 590\uac1c\uac00 \ub098\uc635\ub2c8\ub2e4. \ub9e5\uc8fc \ubb38\uc11c\uac00 \uc815\ud655\ud788 5,891\uac1c\uc774\ubbc0\ub85c 10\uac1c\uc758 \uc138\ud2b8\uac00 589\uac1c\uc774\uace0 \ucd5c\uc885 \ud398\uc774\uc9c0\uc5d0\ub294 1\uac1c\uc758 \ubb38\uc11c\ub9cc \uc788\ub2e4\ub294 \ub73b\uc785\ub2c8\ub2e4. 5,891 \/ 10 = 589.1\uc774\ubbc0\ub85c N1QL\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.\u00a0<u><a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/current\/n1ql\/n1ql-language-reference\/numericfun.html\" target=\"_blank\" rel=\"noopener noreferrer\">CEIL \uae30\ub2a5<\/a><\/u>\u00a0\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc815\uc218\uc758 \ud398\uc774\uc9c0 \uc218\ub97c \uc5bb\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uc5b4\ub5a4 \ud504\ub7f0\ud2b8\uc5d4\ub4dc \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc774\ub4e0 0.1\ud398\uc774\uc9c0\ub97c \ud45c\uc2dc\ud558\uc9c0 \uc54a\uc744 \uac83\uc774\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc591\uc870\uc7a5 \ubc0f \uae30\ud0c0 \ubb38\uc11c\ub97c \uc81c\uc678\ud558\uace0 \ub9e5\uc8fc \ubb38\uc11c\ub85c\ub9cc \ubb38\uc11c\ub97c \uc904\uc774\ub824\uba74 \uc5ec\uae30\uc5d0 WHERE \uc808\uc774 \ud544\uc694\ud558\ub2e4\ub294 \uac83\uc744 \uba85\uc2ec\ud558\uc138\uc694.  WHERE\uac00 \ub204\ub77d\ub418\uba74 \ud655\uc2e4\ud788 \uc798\ubabb\ub41c \ubc88\ud638\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/community\/community-writers-program\/\"><em>\uc774 \uac8c\uc2dc\ubb3c\uc740 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ucee4\ubba4\ub2c8\ud2f0 \uae00\uc4f0\uae30 \ud504\ub85c\uadf8\ub7a8\uc758 \uc77c\ubd80\uc785\ub2c8\ub2e4.<\/em><\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>M. David Allen is a full-stack software engineer and entrepreneur who for more than a decade has been working with just about every different programming language and different type of database system he could get his hands on. \u00a0David has [&hellip;]<\/p>","protected":false},"author":53,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1816,1812],"tags":[2044],"ppma_author":[9026],"class_list":["post-3968","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-couchbase-server","category-n1ql-query","tag-paging"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.5 (Yoast SEO v26.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Paging Data Queries with N1QL - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"Dive into paging data queries with N1QL. Guest author David Allen shows us how to use a docker instance and learn about common paging use cases.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/ko\/paging-data-queries-with-n1ql\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Paging Data Queries with N1QL\" \/>\n<meta property=\"og:description\" content=\"Dive into paging data queries with N1QL. Guest author David Allen shows us how to use a docker instance and learn about common paging use cases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/paging-data-queries-with-n1ql\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-25T08:09:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T00:23:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/Simple-Small-Headshot-450x300-compressed.png\" \/>\n\t<meta property=\"og:image:width\" content=\"450\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Laura Czajkowski, Developer Community Manager, Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Laura Czajkowski, Developer Community Manager, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/\"},\"author\":{\"name\":\"Laura Czajkowski, Developer Community Manager, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/5f1a0ece4e644bc8c037686fbc8f3220\"},\"headline\":\"Paging Data Queries with N1QL\",\"datePublished\":\"2017-08-25T08:09:33+00:00\",\"dateModified\":\"2025-06-14T00:23:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/\"},\"wordCount\":1325,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"keywords\":[\"Paging\"],\"articleSection\":[\"Couchbase Server\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/\",\"name\":\"Paging Data Queries with N1QL - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2017-08-25T08:09:33+00:00\",\"dateModified\":\"2025-06-14T00:23:17+00:00\",\"description\":\"Dive into paging data queries with N1QL. Guest author David Allen shows us how to use a docker instance and learn about common paging use cases.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Paging Data Queries with N1QL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/5f1a0ece4e644bc8c037686fbc8f3220\",\"name\":\"Laura Czajkowski, Developer Community Manager, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/9deb07d5daaa00220534c31768bc4409\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/bc8eebaf25cbe39bc12fd7b1ef92550becc3953ab877a3f0285a59ec2d30b754?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/bc8eebaf25cbe39bc12fd7b1ef92550becc3953ab877a3f0285a59ec2d30b754?s=96&d=mm&r=g\",\"caption\":\"Laura Czajkowski, Developer Community Manager, Couchbase\"},\"description\":\"Laura Czajkowski is the Snr. Developer Community Manager at Couchbase overseeing the community. She\u2019s responsible for our monthly developer newsletter.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/laura-czajkowski\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Paging Data Queries with N1QL - The Couchbase Blog","description":"N1QL\ub85c \ud398\uc774\uc9d5 \ub370\uc774\ud130 \ucffc\ub9ac\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694. \uac8c\uc2a4\ud2b8 \uc791\uc131\uc790 David Allen\uc774 \ub3c4\ucee4 \uc778\uc2a4\ud134\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uacfc \uc77c\ubc18\uc801\uc778 \ud398\uc774\uc9d5 \uc0ac\uc6a9 \uc0ac\ub840\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/ko\/paging-data-queries-with-n1ql\/","og_locale":"ko_KR","og_type":"article","og_title":"Paging Data Queries with N1QL","og_description":"Dive into paging data queries with N1QL. Guest author David Allen shows us how to use a docker instance and learn about common paging use cases.","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/paging-data-queries-with-n1ql\/","og_site_name":"The Couchbase Blog","article_published_time":"2017-08-25T08:09:33+00:00","article_modified_time":"2025-06-14T00:23:17+00:00","og_image":[{"width":450,"height":300,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/Simple-Small-Headshot-450x300-compressed.png","type":"image\/png"}],"author":"Laura Czajkowski, Developer Community Manager, Couchbase","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Laura Czajkowski, Developer Community Manager, Couchbase","Est. reading time":"7\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/"},"author":{"name":"Laura Czajkowski, Developer Community Manager, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/5f1a0ece4e644bc8c037686fbc8f3220"},"headline":"Paging Data Queries with N1QL","datePublished":"2017-08-25T08:09:33+00:00","dateModified":"2025-06-14T00:23:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/"},"wordCount":1325,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","keywords":["Paging"],"articleSection":["Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/","url":"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/","name":"Paging Data Queries with N1QL - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2017-08-25T08:09:33+00:00","dateModified":"2025-06-14T00:23:17+00:00","description":"N1QL\ub85c \ud398\uc774\uc9d5 \ub370\uc774\ud130 \ucffc\ub9ac\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694. \uac8c\uc2a4\ud2b8 \uc791\uc131\uc790 David Allen\uc774 \ub3c4\ucee4 \uc778\uc2a4\ud134\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uacfc \uc77c\ubc18\uc801\uc778 \ud398\uc774\uc9d5 \uc0ac\uc6a9 \uc0ac\ub840\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/paging-data-queries-with-n1ql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Paging Data Queries with N1QL"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","description":"NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4, Couchbase","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/5f1a0ece4e644bc8c037686fbc8f3220","name":"Laura Czajkowski, \uac1c\ubc1c\uc790 \ucee4\ubba4\ub2c8\ud2f0 \uad00\ub9ac\uc790, Couchbase","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/9deb07d5daaa00220534c31768bc4409","url":"https:\/\/secure.gravatar.com\/avatar\/bc8eebaf25cbe39bc12fd7b1ef92550becc3953ab877a3f0285a59ec2d30b754?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bc8eebaf25cbe39bc12fd7b1ef92550becc3953ab877a3f0285a59ec2d30b754?s=96&d=mm&r=g","caption":"Laura Czajkowski, Developer Community Manager, Couchbase"},"description":"\ub85c\ub77c \ucc60\ucf54\ube0c\uc2a4\ud0a4\ub294 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 Snr. \uac1c\ubc1c\uc790 \ucee4\ubba4\ub2c8\ud2f0 \ub9e4\ub2c8\uc800\ub85c \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 \ucee4\ubba4\ub2c8\ud2f0\ub97c \ucd1d\uad04\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub140\ub294 \uc6d4\uac04 \uac1c\ubc1c\uc790 \ub274\uc2a4\ub808\ud130\ub97c \ub2f4\ub2f9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.","url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/laura-czajkowski\/"}]}},"authors":[{"term_id":9026,"user_id":53,"is_guest":0,"slug":"laura-czajkowski","display_name":"Laura Czajkowski, Developer Community Manager, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/bc8eebaf25cbe39bc12fd7b1ef92550becc3953ab877a3f0285a59ec2d30b754?s=96&d=mm&r=g","author_category":"","last_name":"Czajkowski","first_name":"Laura","job_title":"","user_url":"","description":"\ub85c\ub77c \ucc60\ucf54\ube0c\uc2a4\ud0a4\ub294 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 Snr. \uac1c\ubc1c\uc790 \ucee4\ubba4\ub2c8\ud2f0 \ub9e4\ub2c8\uc800\ub85c \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 \ucee4\ubba4\ub2c8\ud2f0\ub97c \ucd1d\uad04\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub140\ub294 \uc6d4\uac04 \uac1c\ubc1c\uc790 \ub274\uc2a4\ub808\ud130\ub97c \ub2f4\ub2f9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/3968","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=3968"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/3968\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=3968"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=3968"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=3968"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=3968"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}