SQL문 |
MongoDB문 |
SELECT * FROM members; |
db.members.find() |
SELECT rowid,mem_no,type
FROM members; |
db.members.find(
{},
{mem_no:1, type:1}
) |
SELECT mem_no, type
FROM members; |
db.members.find(
{},
{ mem_no;1, type:1, _id:0}
) |
SELECT *
FROM members
WHERE type = "ACE"; |
db.members.find(
{type:"ACE"}
) |
SELECT mem_no, type
FROM members
WHERE type = "ACE"; |
db.members.find(
{type:"ACE"},
{ mem_no;1, type:1, _id:0}
) |
SELECT *
FROM members
WHERE type != "ACE"; |
db.members.find(
{type: { $ne: "ACE"} }
) |
SELECT *
FROM members
WHERE type = "ACE";
AND age = 49; |
db.members.find(
{type:"ACE", age:49}
) |
SELECT *
FROM members
WHERE type = "ACE";
OR age = 49; |
db.members.find(
{$or: [ {type:"ACE"}, {age:49} ] }
) |
SELECT *
FROM members
WHERE age > 45; |
db.members.find(
{age: { $gt: 45} }
) |
SELECT *
FROM members
WHERE age < 55; |
db.members.find(
{age: { $lt: 55} }
) |
SELECT *
FROM members
WHERE age > 45
AND age <= 55; |
db.members.find(
{age: { $gt: 45 , $lte:55}}
) |
SELECT *
FROM members
WHERE mem_no
like "%2013%"; |
db.members.find(
{ mem_no: /2013/}
) |
SELECT *
FROM members
WHERE mem_no
like "T%"; |
db.members.find(
{ mem_no: /^T/}
) |
SELECT *
FROM members
WHERE type = "ACE"
ORDER BY mem_no ASC; |
db.members.find( { type: "ACE" } ).sort( {
mem_no:1}) |
SELECT *
FROM members
WHERE type = "ACE"
ORDER BY mem_no DES; |
db.members.find( { type: "ACE" } ).sort( {
mem_no:-1}) |
SELECT COUNT
FROM members; |
db.members.count()
db.memers.find().count() |
SELECT COUNT(mem_no)
FROM members; |
db.members.count( { mem_no: {$exists:true} })
db.members.find( { mem_no: {$exists:true} }).
count() |
SELECT COUNT(*)
FROM members
WHERE age > 45; |
db.members.count( { age: {$gt:45}})
db.members.find( { age: {$gt:45}}).count() |
SELECT DISTINCT type
FROM members; |
db.members.distinct("type") |
SELECT *
FROM members
WHERE rownum =1; |
db.members.findOne()
db.members.find().limit(1) |
EXPLAIN PLAN
SELECT *
FROM members
WHERE type = "ACE"; |
db.members.find( { type:"ACE"}).explain() |