꿈라CBT아래 EMP 테이블에 대해 두 컬럼 A, B의 값이 서로 다른 결과가 되는 SQL은?
보기
[EMP 테이블]
| EMPNO | SAL |
|---|---|
| 7001 | 5000 |
| 7002 | 3500 |
| 7003 | 2800 |
| 7004 | 2000 |
- 1SELECT SUM(SAL) AS A, SUM(SAL) AS B FROM EMP;
- 2SELECT COUNT(SAL) AS A, COUNT(SAL) AS B FROM EMP;
- 3SELECT AVG(SAL) AS A, AVG(SAL) AS B FROM EMP;
- 4SELECT MAX(SAL) AS A, MIN(SAL) AS B FROM EMP;