mongoDB的使用
1. MongoDB的分组查询 : group by...
db.table_job.aggregate({"$group":{_id: '$sqlModelName',max_value:{"$max":"$createTime"}}});
table_job ----->document name
转化成SQL:
select sqlModelName,max(createTime)
from table_job
group by sqlModelName;
2. MongoDB的筛选条件 排序 限制记录数 where... order by... limit ...
db.table_job.find({'createTime':{"$gt":'2019-08-23 13:57:29:299'}}).projection({}).sort({ _id: -1 }).limit(1000);
select *
from table_job
where createTime>'2019-08-23 13:57:29:299'
order by _id desc
limit 1000;