SQL AND OPERATOR

The SQL AND clause is used when you want to specify more than one condition in your SQL WHERE clause, and at the same time you want all conditions to be true.

For example if you want to select all Company with FirstName "Scott" and LastName "Armstrong", you will use the following SQL expression:

SELECT * FROM Company

WHERE FirstName = 'Scott' AND LastName = 'Armstrong'

The result of the SQL query above is:

FirstName	LastName	Email	DOB	Phone
Scott	Armstrong	Armstrong.yahoo.com	2/4/1968	887-676-2321

MORE BASIC SQL COMMANDS