AND Operator

In the AND operator if both conditions of the statements are TRUE it return TRUE. If one of them is False It return FALSE value.

Example

SELECT * FROM emp WHERE deptno=10 AND sal >=4000;
This would display as follows in given table:

EMPNO   ENAME          JOB            MGR      HIREDATE       SAL      COMM    DEPTNO
1383          Saran    PRESIDENT          -        17-NOV-81      5000        10

The given example checks for both the conditions and the records which match both the conditions are alone shows. All the records with deptno 10 and sal greater than or equal to 4000 are displayed.