SQL AND Clausecan't see properly

AND operator displays a record if both the first condition and the second condition is true.

syntax

SELECT COLUMN1, COLUMN2 from TABLE_NAME where column1 operator value AND Column2 operator value

Demo Database (Customer Table)

CustomerID CustomerName ContactName Address City PostalCode Country
1 Alfreds Futterkiste Maria Anders Obere Str. 57 Berlin 12209 Germany
2 Ana Trujillo Emparedados y helados Ana Trujillo Avda. de la Constitucion 2222 Mexico D.F. 05021 Mexico
3 Antonio Moreno Taqueria Antonio Moreno Mataderos 2312 Mexico D.F. 05023 Mexico

example

SELECT * FROM Customers WHERE Country='Germany' AND City='Berlin';

Above Statement select all the data where country is Germany and City is Berlin..

CustomerID CustomerName ContactName Address City PostalCode Country
1 Alfreds Futterkiste Maria Anders Obere Str. 57 Berlin 12209 Germany

For More References:

MySQL DML 

Oracle DML

Loading Questions

If you are facing any issue like can not see video so please login into Google with email what you forwarded to us Google Login or mail to administrator qatraining@infotek-solutions.com