S10 Select AND OR NOT

S10 Select AND OR NOT

AND

SELECT * FROM regtable
WHERE Country=’India’ AND City=’Delhi’;

OR

SELECT * FROM regtable
WHERE City=’Delhi’ OR City=’Mumbai’;

NOT

SELECT * FROM regtable
WHERE NOT Country=’Delhi’;

Combining

SELECT * FROM regtable
WHERE Country=’India’ AND (City=’Delhi’ OR City=’Mumbai’);

SELECT * FROM regtable
WHERE NOT Country=’India’ AND NOT Country=’Poland’;

Take Your Free Live Demo Class Now

Enter Your DETAILS BELOW

To Get Complete Information or We Will Call You

We Will Send You the Course Fees Details In Below Number

Enter Your DETAILS BELOW

We Will Call Back You Shortly

Enter Your DETAILS BELOW

We Will Call Back You Shortly

Enter Your DETAILS BELOW

Enter Your DETAILS BELOW TO take

free demo class