Logical AND Operator

 Subscribe in a reader

 

It can be used in any valid SQL statement such as select,insert,update,or delete. the and operator requires that each condition must be met for the record to be included in the result set.

 

 

    syntax

 

    insert into table name where condition1 AND condition2

 

    update tablename set columnname values value where condition1 AND condition2

 

    delete from tabl name where condition1 AND condition2

 

    select from tablname where condition1 AND condition2

 

 

 

    EXAMPLE

 

    insert into sqldemo1 (id) values (23) where firstname='sam' AND pass='sam';

 

    Update sqldemo1 set id=34 where firstname='sam' AND pass='sam';

 

    Delete * from sqldemo1 where firstname='sam' AND pass='sam';

 

    select id from sqldemo1 where firstname='sam' AND pass='sam';