表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模拟题库