学员出去2021-12-22面试遇到的真题,分享给大家
参考答案:
第一题:
SELECT
*
FROM
emp
ORDER BY
deptno DESC,
sal ASC;
第二题:
SELECT
deptno,
job,
avg( sal )
FROM
emp
WHERE
deptno = ( SELECT deptno FROM emp WHERE empno = 7839 ) GROUP BY deptno,
job;
学员出去2021-12-22面试遇到的真题,分享给大家
参考答案:
第一题:
SELECT
*
FROM
emp
ORDER BY
deptno DESC,
sal ASC;
第二题:
SELECT
deptno,
job,
avg( sal )
FROM
emp
WHERE
deptno = ( SELECT deptno FROM emp WHERE empno = 7839 ) GROUP BY deptno,
job;