주말 - SQL 11, 12, 13, 14 번 과제

 11.  논리연산 ( AND , OR 실습 WHERE11 )

SELECT*

 FROM emp 

WHERE job = 'SALESMAN' 

OR hiredate >= TO_DATE ( ' 1981/06/01' , 'YYYY/MM/DD ') ; 

12. 논리연산 (AND , OR 실습 where 12 ) 

SELECT * 

FROM emp

WHERE job = 'SALESMAN' 

OR empno LIKE  '78%' ;

13. 

SELECT * 

FROM emp

WHERE job =   'SALESMAN' 

OR empno BETWEEN '78' AND '78' 

AND empno BETWEEN '780' AND '789'

AND empno BETWEEN '7800' AND '7899' ; 

like연산자로 풀어보기 

SELECT *

FROM emp 

WHERE emp LIKE '78%'

14. 

SELECT * 

FROM emp 

WHERE (  job = ' SALESMAN' 

OR  empno LIKE  '78%' ) 

AND hiredate >= TO_DATE ('1981/06/01' , 'YYYY/MM/DD')