MongoDB-投影操作(1)-$slice_projectionoperation slice 写法使用-CSDN博客

本文介绍了MongoDB中$slice操作符的功能及其使用方法。$slice用于控制查询返回的数组元素数量，可通过正数、负数及数组形式指定要返回的元素范围。文章通过多个实例展示了如何选取数组中的前几项、后几项以及跳过某些项后的特定数量元素。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

$slice (projection)

The $slice operator controls the number of items of an array that a query returns. For information on limiting the size of an array during an update with$ push, see the $slice modifier instead.

Consider the following prototype query:

db.collection.find( { field: value }, { array: {$slice: count } } );

This operation selects the document collection identified by a field named field that holds value and returns the number of elements specified by the value of count from the array stored in the array field. If count has a value greater than the number of elements in array the query returns all elements of the array.

$slice accepts arguments in a number of formats, including negative values and arrays. Consider the following examples:

db.posts.find( {}, { comments: { $slice: 5 } } )

Here, $slice selects the first five items in an array in the comments field.

db.posts.find( {}, { comments: { $slice: -5 } } )

This operation returns the last five items in array.

The following examples specify an array as an argument to $slice. Arrays take the form of [ skip , limit ], where the first value indicates the number of items in the array to skip and the second value indicates the number of items to return.

db.posts.find( {}, { comments: { $slice: [ 20, 10 ] } } )

Here, the query will only return 10 items, after skipping the first 20 items of that array.

db.posts.find( {}, { comments: { $slice: [ -20, 10 ] } } )

This operation returns 10 items as well, beginning with the item that is 20th from the last item of the array.