$skip (Aggregation) in MongoDB

This operator uses to skip first to n documents and remaining will be passed in the next pipeline. n= skip number.

Syntax:


{$skip:<positive integer>}


See the following example


use Test



db.Inventory.insert(
{
"Title":"MongoDB Tutorial by codefari.com",
"ISBN":"1990987666765",
"AccessCountry":["India","China"],
})
db.Inventory.insert(
{
"Title":"SQL Server tutorial by codefari.com",
"ISBN":"9909876765476",
"AccessCountry":["USA"],
})
db.Inventory.insert(
{
"Title":"C# tutorial by codefari.com",
"ISBN":"8898877676544",
"AccessCountry":["UK"],
})
db.Inventory.find()


output


/* 0 */
{
    "_id" : ObjectId("5655b294583c040b3341b96e"),
    "Title" : "MongoDB Tutorial by codefari.com",
    "ISBN" : "1990987666765",
    "AccessCountry" : [
        "India",
        "China"
    ]
}

/* 1 */
{
    "_id" : ObjectId("5655b294583c040b3341b96f"),
    "Title" : "SQL Server tutorial by codefari.com",
    "ISBN" : "9909876765476",
    "AccessCountry" : [
        "USA"
    ]
}

/* 2 */
{
    "_id" : ObjectId("5655b294583c040b3341b970"),
    "Title" : "C# tutorial by codefari.com",
    "ISBN" : "8898877676544",
    "AccessCountry" : [
        "UK"
    ]
}


Now if we want to skip 2 records then we will use $skip



db.Inventory.aggregate(
    {$skip:2}
)


Output


/* 0 */
{
    "result" : [
        {
            "_id" : ObjectId("5655b294583c040b3341b970"),
            "Title" : "C# tutorial by codefari.com",
            "ISBN" : "8898877676544",
            "AccessCountry" : [
                "UK"
            ]
        }
    ],
    "ok" : 1
}


No comments:

Post a Comment

PostgreSQL: How to change the password of the user

This article will teach you to change the password of the user in PostgreSQL. To change the password, we use the ALTER ROLE, its uses are ...