nosqlzoo刷题-1

• find(查找)

1. Use to show the details of Germany. .find() Show Germany instead of France.

db.world.find({
  name: 'France'
});

2. You can use to make the output more readable. .pretty() List all the countries in the continent of “Eurasia”.

db.world.find({
  name: 'Germany'
}).pretty();

3. You can test numbers as well as strings.Find the country with an area of exactly 43094.

db.world.find({
  gdp: 3425956000000
}).pretty();

4. You can use $gt (greater than) and $lt (less than) to compare numbers and strings.Show each country with a population of over 250000000 Sort the results alphabetically.You will need to use a projection to answer this question.

db.world.find({
  population: {
    $gt: 250000000
  }
}, {
  name: 1,
  _id: 0
}).sort({
  name: 1
}).pretty();

5. Greater than and less than comparisons can also be applied to strings.List the countries that come after “S” in the alphabet.

db.world.find({
  name: {
    $gt: 'S%'
  }
}, {
  name: 1,
  _id: 0
}).sort({
  name: 1
}).pretty();

6. Find the name and capital cities for countries with a population of over 70 million.

db.world.find({
  population: {
    $gt: 70000000
  }
}, {
  name: 1,
  capital: 1,
  _id: 0
}).sort({
  name: 1
}).pretty();

7. Find the countries that have a population that is over 200 million or less than 20,000.

db.world.find({
  $or: [{
    population: {
      $lt: 20000
    }
  }, {
    population: {
      $gt: 200000000
    }
  }]
}, {
  name: 1,
  population: 1,
  _id: 0
});

• 总结：

1. find用于查找数据，加上.pretty就是显示详细的数据，要显示一条数据可以采用加一个变量条件比如{name:1,_id:0}。
2. 字符串匹配与sql相同，S%匹配以S为首字母的字母。
3. $gt：表示大于某数字与字符串，$lt：表示小于某字符串与数字；$or的用法：放在条件的最里面项。