SQLD · 제55회 · 16번

Question

다음 중 SQL 실행 결과 집합이 나머지와 다른 하나는?

Accepted Answer

SELECT A, B FROM T GROUP BY A, B;

Answer

SELECT A, B FROM T GROUP BY ROLLUP(A, B);

Answer

SELECT A, B FROM T GROUP BY GROUPING SETS(A, B, ( ));

Answer

SELECT A, B FROM T GROUP BY GROUPING SETS((A, B), A, ( ));