【JAVADAY20】-MYSQL数据库34个案例
console.sqlselect *from emp;select *from dept;select *from salgrade;select DEPTNO '部门号', max(SAL) '最大薪资'from empwhere SAL > 3000group by DEPTNO;#找出每个部门的平均薪资，要求显示平均薪资高于2500的select DEPTNO, avg(SAL)from empgroup by DEPTNOhaving avg(SAL)...
