摘要: 1.聚合函数 count(id) 不为null的id数 2.分组 + 聚合 group by eg.select country,countid) from sanguo group by country; 3.分组筛选 having eg.select country,count(id) as c 阅读全文
posted @ 2019-07-09 18:37 圣枷 阅读(177) 评论(0) 推荐(0) 编辑