select owner,count(*) as count from table1 where owner in (select xx.owner from (select owner from table1 where DATE_SUB(CURDATE(), INTERVAL 1 DAY) <= date(date) and range>="75" group by owner order by count(*) desc limit 20) as xx) group by owner order by count desc;
mysql中子查询limit用法备忘
最新推荐文章于 2022-08-29 14:25:50 发布