1、支持一定的sql函数max、min、avg、sum、count
2、支持sql中的group by、order by、limit
3、支持各个sql函数之间的配合使用(效率还行)
例如:统计七天以内musicId被使用最多的前十名
Long now = System.currentTimeMillis();
// Long now = 1573643766000L;
Long startTime = now - 24L*60*60*7*1000;
String sql = "select musicId,count(*) totalListNum from video_message where musicId is not null and lastUpdateTime >= " + startTime +
" and lastUpdateTime < "+ now +
" group by musicId order by count(*) desc limit 10";