WITH tmp AS(SELECT sum(sessioncount) as visitCount, appid from t_stat_visit where stattype = '1' GROUP BY appid)SELECTt1.*, t2.visitCountFROMt_e_oauth_application t1 LEFT JOIN tmp t2 on t1.appid = t2.appidWHEREEXISTS (SELECTIDFROMt_e_app_versionWHEREt1. ID = t_e_app_version.appidAND t_e_app_version.status = '6')AND t1.createorid = #{creatorId}ORDER BY lastmodifytime DESC
每天学习一点点 编程PDF电子书、视频教程免费下载：http://www.shitanlife.com/code
转载于:https://www.cnblogs.com/scode2/p/9044201.html
相关资源：SQL基础教程-Mick-示例程序&习题答案