SQLD(SQL 개발자) 기출 · DML

이 문제 풀어보기

1. 1.SELECT T.COL1 C1, T.COL2 AS "C1" FROM TABLE1 T WHERE T.COL2 IN ('A', 'B') ORDER BY 1, "C1";
2. 2.SELECT T.COL1 C1, TABLE1.COL2 AS C2 FROM TABLE1 T WHERE TABLE1.COL2 = 'A' ORDER BY 1, 2;
3. 3.SELECT TABLE1.COL1, SUM(TABLE1.COL2) FROM TABLE1 GROUP BY TABLE1.COL1 ORDER BY COL1;
4. 4.SELECT T.COL1 C1, T.COL2 AS C2 FROM TABLE1 T WHERE T.COL1 = 4;