Question

아래 SQL 중 출력 결과가 다른 것은?

Accepted Answer

SELECT * FROM EMP WHERE DEPTNO = 10 OR DEPTNO = 20 AND JOB = 'CLERK' OR SAL > 3000;

Answer

SELECT * FROM EMP WHERE (DEPTNO = 10 OR DEPTNO = 20) AND JOB = 'CLERK' OR SAL > 3000;

Answer

SELECT * FROM EMP WHERE (DEPTNO = 10 AND JOB = 'CLERK') OR (DEPTNO = 20 AND JOB = 'CLERK') OR SAL > 3000;

Answer

SELECT * FROM EMP WHERE DEPTNO IN (10,20) AND JOB = 'CLERK' OR SAL > 3000;

SQLD(SQL 개발자) 기출 · DML

이 문제 풀어보기