表emp有如下字段：deptno, empid, name, job, sal。分别表示：部门编号、员工编号、员工姓名、职位、薪资。求每个部门的工资占比，结果用百分号表示，保留2位小数。以下代码正确的是（ ）

A.        select deptno, sum(sal)/(select sum(sal) from emp) from emp;

B.        select deptno, sum(sal)/(select sum(sal) from emp) from emp group by deptno;

C.        select deptno, concat(round(sum(sal)/(select sum(sal) from emp)*100,2),“%”) from emp group by deptno;

D.        select deptno, concat(round(sum(sal)/(select sum(sal) from emp),2),“%”) from emp group by deptno;

题目来源于CDA模拟题库


点击此处获取答案