|
AND , OR , NOT
AND
AND is a logical condition used in SQl Statments.It returns True if both the conditions are True.Returns False if either is False.Otherwise returns unknown.
Syntax ::
[<SELECT>] FROM <TABLE>
WHERE [<CONDITION1>] AND ....AND [<CONDITIONX>] ;
Example ::
SELECT * FROM CUSTOMER
WHERE CUST_NAME='JOHN' AND CUST_DEPTID=10;
|
OR
OR is a logical condition used in SQl Statments.It returns True if either conditions are True.Returns False if both are False.Otherwise returns unknown.
Syntax ::
[<SELECT>] FROM <TABLE>
WHERE [<CONDITION1>] OR....OR [<CONDITIONX>] ;
Example ::
SELECT * FROM CUSTOMER
WHERE CUST_NAME='JOHN' OR CUST_DEPTID=10;
|
NOT
NOT is a logical condition used in SQl Statments.It returns True if the following condition is False . Returns False if the following condition is True.
Syntax ::
[<SELECT>] FROM <TABLE>
WHERE NOT <CONDITION>;
Example ::
SELECT * FROM CUSTOMER
WHERE NOT ( CUST_SAL IS NULL );
|
|
|
