OBJECTIVE: AND OPERATION

Script:

Select EMPNO, ENAME, JOB from emp where job ='CLERK' AND SAL >= 800

 

EMP Table:

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)

MySQL

PostgreSQL