以图明志

数据库技术

SQL笔试题:公司员工与部门查询

一道面试题,可以补充你SQL知识的不足
列出EMPLOYEES表中各部门的部门号,最高工资,最低工资:select max(SALARY) as 最高工资,min(SALARY) as 最低工资,DEPARTMENT_ID from EMPLOYEES group by DEPARTMENT_ID;
1 / 1 首页 < Prev 1 Next > 尾页 页码: