mysql分组后的总数

来源:互联网 发布:淘宝中和银座 编辑:程序博客网 时间:2024/05/02 01:39

select count(*) from (select lt.id   from table1 as t1  LEFT JOIN table2 as t2  on t1.id = t2.c_id   GROUP BY t1.id) as t


记一下,别到时候又忘了,要去搜索

0 0