2022年3月5日
SQL-分组聚合-子查询
摘要： -- having前面必须有group byselect e.deptno ,sum(e.sal) as sum_sal ,min(e.sal) as min_sal ,max(e.sal) as max_sal ,avg(e.sal) as avg_sal ,count(e.ename) as c 阅读全文
posted @ 2022-03-05 17:10 oNice 阅读(145) 评论(0) 推荐(0) 编辑