大数据可以采用子查询

(SELECT record_id,created,1,title,content,learning FROM oa_safetyreport_record where record_id > (select record_id from oa_safetyreport_record limit 200000,1))
union ALL
(SELECT record_id,created,2,title,content,null FROM oa_submission_record where record_id > (select record_id from oa_safetyreport_record limit 200000,1))
-- where created > 1498464558000
order by created
limit 10;

原文地址:https://www.cnblogs.com/taikongliu/p/7157229.html