A.
SELECT AVG(sal) FROM emp;
B.
SELECT deptno,AVG(sal) FROM emp GROUP BY deptno;
C.
SELECT deptno,job,AVG(sal) FROM emp GROUP BY deptno,job;
D.
SELECT deptno,AVG(sal) FROM emp GROUP BY deptno HAVING job=’clerk’;

扫码回复“10312931”查看答案
题库
|
楼主: CDA网校
|
1156
0
[问题] 以下SQL语句中,错误的是() |
|
已卖:189份资源 泰斗 3%
-
|
| ||
![]() |
|||
|
|
加好友,备注cda京ICP备16021002号-2 京B2-20170662号
京公网安备 11010802022788号
论坛法律顾问:王进律师
知识产权保护声明
免责及隐私声明


