distinct query with array in mongodb?

Question

Hi i want to get the distict values in mongodb.

this is my example table

Name________________Age___________________Salary

x ___________________ 25 ___________________5000

x ___________________ 26 ___________________5000

y ___________________ 25 ___________________5000

y ___________________ 26 ___________________5000

I want to get the result like this

    {

        "Name" : "x",
    "Age" : [ 
            {
                25,26

            }]
    }

{

        "Name" : "y",
    "Age" : [ 
            {
                25,26

            }]
    }

is there any way to get the result like this.

my sql query is

select distinct Name,Age from Table where salary=5000

i tried like this

but this is not able to get like this

db.getCollection('Table').aggregate([
{"$match":{Salary:5000}},
{"$group":{_id:{Name:"$Name",Age:"$Age"}}},
{"$project" : {_id:0, Name:"$_id.Name", Age:"$_id.Age"}}
])

s7vr · Accepted Answer · 2017-04-24 12:32:55Z

2

Use $addToSet for distinct Age when $grouping on Name to get the desired output.

db.getCollection('Table').aggregate([
{"$match":{Salary:5000}},
{"$group":{_id:"$Name", "Age":{$addToSet:"$Age"}}},
{"$project" : {_id:0, Name:"$_id", Age:1}}
])

answered Apr 24, 2017 at 12:32

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Vinoth Over a year ago

Hi veeram I have one doubt in MongoDB query. Select (Distinct Name),Age,Salary from Table. I want to get Name only distinct, either column are not want to show as distinct but i want to show all the columns as per without distinct including _id column value. Can you give me the answer

s7vr Over a year ago

Use $push for each of the column in the group. Something like "Salary":{"$push":"$Salary"}

Vinoth Over a year ago

where should i give the query. Can you add this answer for "Salary and Age"column

s7vr Over a year ago

Something like {"$group":{_id:"$Name", "Age":{$push:"$Age"}, Salary ...}},

Collectives™ on Stack Overflow

distinct query with array in mongodb?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related