WHERE

The WHERE is used to filter records. Like we want to see only mexico country customers. the we'll write.->

SELECT * FROM Customers WHERE Country='mexico'

Text Field Vs Numeric Field.

SQL requires single quotes around text values (most database systems will also allow double quotes). To See Customers data by id write ->

SELECT * FROM Customers WHERE CustomerId = 2

BETWEEN Statement is used to find data in a range.

SELECT * FROM Products WHERE Price BETWEEN 20 AND 30

LIKE Statement is used to find data Alphabet Wise.

SELECT * FROM Products WHERE City LIKE 'b%'

To Check data from city wise then use IN.

SELECT * FROM Customers WHERE City IN ('Paris','London')

Not is used to check the specific city record that is whether exist or not.

 SELECT * FROM Customers WHERE NOT City = 'Berlin';