Lecture8.txt

Lecture-8:
NOT Operator in SQL || NOT Operator With Example:
NOT Operator: It is used in SQL to provide or to get negative result or used in SQL to get opposite result.
Condition:
                               X                 Output
                               0                    1
                               1                    0 
Syntax: select *(or use “column_name”) from table_name where NOT condition;
Example: Amazon => Database => Customer
                Sl. No.            Name                     Address                         Age
                   1.               Rupu                    Agarpara                         22
                   2.               Rup             Salt Lake, Sector-5                      20
                   3.              Rupayan                    Fulia                          24
                   4.               Rupi                     Newtown                         21
Command1: select Name from Customer where NOT Address=”Salt Lake, Sector-5”;
Output1: Rupu, Rupayan, Rupi

NOT use with Between:
Command2: select Name from Customer where NOT Age Between 21 AND 24;
Output2: Rup

NOT use with IN:
Command3: select Name from Customer where NOT Address IN (“Salt Lake, Sector-5”, “Newtown”);
Output3: Rupu, Rupayan

                                                      -------×-------