SQLD · 모의고사 7회 · 14번

Question

다음 SQL 문장 중 다른 세 문장과 동일한 행을 집계하지 않는 것은?

Accepted Answer

SELECT COUNT(*) FROM EMPLOYEE WHERE ACTIVE_YN = 'Y' AND (DEPT = 'HR' OR GRADE = 'A');

Answer

SELECT COUNT(*) FROM EMPLOYEE WHERE ACTIVE_YN = 'Y' AND DEPT = 'HR' OR GRADE = 'A';

Answer

SELECT COUNT(*) FROM EMPLOYEE WHERE (ACTIVE_YN = 'Y' AND DEPT = 'HR') OR GRADE = 'A';

Answer

SELECT COUNT(*) FROM EMPLOYEE WHERE (ACTIVE_YN = 'Y' AND DEPT = 'HR' OR GRADE = 'A');