Oracle(董老师上课笔记(三))接(二)
EX37. 求每一年入职的员工人数select count(empno) , extract( year from hiredate ) from empgroup by extract( year from hiredate ) ;EX38. 求每个部门的平均工资select deptno , avg(sal) from emp group by deptno ;EX39. 求平...
原创
2018-09-02 15:25:31 ·
162 阅读 ·
0 评论