代码改变世界

随笔分类 -  sql

SQL实例 - 数值计算

2022-09-10 00:02 by ZealouSnesS, 501 阅读, 收藏,
摘要： 1.计算平均值 select deptno,avg(sal) as avg_sal from emp group by deptno 2.求某列中的最小值最大值 select deptno, min(sal) as min_sal, max(sal) as max_sal from emp grou 阅读全文