FALSE :
Select EMPNO, ENAME, JOB from emp where job ='CLERK' AND JOB =
'SALESMAN'
TRUE:
Select EMPNO, ENAME, JOB from emp where job ='CLERK' AND SAL >= 800
Treatment |
TRUE (T) |
Resultant |
FALSE (F) |
Resultant |
T |
T T |
True |
T F |
FALSE |
F |
F T |
FALSE |
F F |
FALSE |
FALSE : (No dual roles, either CLERK OR SALESMAN)
TRUE (Both conditions were true)