1
{
        "eID" : 101,
        "eName" : "Radhey",
        "phone" : 85482245,
        "add" : "ffw djf ffvf",
        "city" : "U.P",
        "Salary Details" : [
                {
                        "Salary" : 56458
                }
        ]
}

as

{
        "eID" : 101,
        "eName" : "Radhey",
        "phone" : 85482245,
        "add" : "ffw djf ffvf",
        "city" : "U.P",
        "Salary" : 56458
} 
flyingfox
  • 13,414
  • 3
  • 24
  • 39

1 Answers1

0

If Salary Details is always an array with a single object in it, as @user20042973 suggested, you can use:

db.collection.find({},
{
  "eID": 1,
  "eName": 1,
  "phone": 1,
  "add": 1,
  "city": 1,
  "Salary Details": {$first: "$Salary Details.Salary"}
})
nimrod serok
  • 14,151
  • 2
  • 11
  • 33