SQLD(SQL 개발자) 기출 · 집합 연산자

이 문제 풀어보기

1. 1.SELECT * FROM Mytest WHERE
   COL1 <= 200
   AND COL2 >= 200;
2. 2.SELECT * FROM Mytest WHERE
   1=1
   AND 200 BETWEEN COL1 AND
   COL2
3. 3.SELECT * FROM Mytset WHERE
   1=1
   AND ( CODE = 'A001' AND 200
   BETWEEN COL1 AND COL2)
   OR ( CODE = 'B001' AND 200
   BETWEEN COL1 AND COL2);
4. 4.SELECT * FROM Mytest WHERE
   1=1
   AND CODE IN ('A001','B001')
   AND COL1 BETWEEN 200 AND 400;