Laravel-admin 聚合和子查询筛选过滤 grid 怎么处理

问答 / 724 / 0 / 创建于 5年前 / 更新于 5年前

SELECT *, COUNT(*) FROM  (SELECT *, count(*) as cnt FROM abc WHERE a = 2 GROUP BY col1 ORDER BY col0) AS f GROUP BY col2;