MongoDB

Type

Category

db.employees.find()

 * Select
From employees

All Column

Select

db.employees.find({},{FIRST_NAME:1,LAST_NAME:1, _id: 0 })

Select First_name,Last_name
From Employees

Limit Column

Select

db.employees.distinct( “JOB_ID” )

Select distinct (job_Id)
From employees

Distinct

Select

db.employees.find({FIRST_NAME : “Donald”})

* Select
From employees
‘where First_name=’Donald

Where

Where Clause

db.employees.find({EMPLOYEE_ID:{$ne: 105}})

* Select
From employees
where Employee_id != 105

!=  –  Not

Where Clause

db.employees.find({EMPLOYEE_ID:{$lt: 105}})

* Select
From employees
where Employee_id > 105

<

Where Clause

db.employees.find({EMPLOYEE_ID:{$lte:105}})

* Select
From employees
where Employee_id <= 105

=>

Where Clause

db.employees.find({EMPLOYEE_ID:{$gt:200}})

* Select
From employees
where Employee_id > 200

<

Where Clause

db.employees.find({EMPLOYEE_ID:{$gte:200}})

* Select
From employees
where Employee_id >= 200

<=

Where Clause

db.employees.find({ $and: [ {SALARY : 2600}, { JOB_ID :   “SH_CLERK”} ] })

* Select
From employees
where salary=2600
‘and job_id=’SH_CLERK

And

Where Clause

db.employees.find({“$or”: [{“SALARY” : 3000   },{ “FIRST_NAME” : ‘Pat’}] })

select  *
from employees
where salary=’3000′ or First_name=’Pat’

Or

Where Clause

db.employees.find({ “FIRST_NAME”:   {“$in”:  [‘David’,’John’]}})

select  *
from employees
where first_name in (‘David’,’John’)

In

Where Clause

db.employees.find({ “EMPLOYEE_ID”:   {“$nin”:  [110,111] }})

select  *
from employees
where employee_id not in (110,111)

Not in

Where Clause

db.employees.find( {FIRST_NAME: /^A/ } )

select *
from employees
where  FIRST_NAME like ‘A%’

Like ‘  %’

Where Clause

db.employees.find( { FIRST_NAME : /on$/ } )

select *
from employees
where  FIRST_NAME like ‘%on’

Like ‘%  ‘

Where Clause

db.employees.find( {FIRST_NAME: /is/ } )

select *
from employees
where FIRST_NAME like ‘%is%’

Like ‘% %’

Where Clause

db.employees.find({SALARY: {$gte: (1400),$lte: (2400)}})

select *
from employees
where salary between 1400 and 2400

Where Clause

db.employees.find().limit(5)

Select *
From employees
Where rownum <=5

Where Clause

db.employees.find().sort({EMPLOYEE_ID: 1})

Select *
From employees
Order By Employee_id ASC

Order By Asc

Order

db.employees.find().sort({EMPLOYEE_ID: -1})

Select *
From employees
Order By Employee_id DESC

  Order By Desc

Order

 db.employees.aggregate([{
“$group”: { “_id”:   {},
“avg”: {   “$avg”: “$SALARY” } } },
{   “$project”: { “avg”: 1, “_id”: 0 } }])

Select avg(salary)
From employees

AVG

Function

db.employees.aggregate([{
$group: {_id: null,
total: { $sum: “$SALARY” }   }}] )

Select sum(salary)
From employees

SUM

Function

db.employees.aggregate( [ {
$group: { _id: null,
total: { $max: “$SALARY” }}} ] )

Select max(salary)
From employees

MAX

Function

db.employees.aggregate( [{
$group: {_id: null,
total: { $min: “$SALARY”   }}}] )

Select min(salary)
From employees

MIN

Function

db.employees.count()

select count(*)
from employees

Count

Function