|
The AND operator displays a record if all the conditions are true. It links together two or more conditional statements for increased filtering when running SQL commands.
Table Name ‘Users’
|
U_Id
|
FirstName
|
LastName
|
City
|
|
1
|
Ajay
|
senha
|
New York
|
|
2
|
Vinda
|
kapoor
|
Los Angeles
|
|
3
|
Qasim
|
bilal
|
New York
|
Statement:
SELECT * FROM Users
WHERE FirstName=' Vinda'
AND City='Los Angeles'
Result:
|
U_Id
|
FirstName
|
LastName
|
City
|
|
2
|
Vinda
|
kapoor
|
Los Angeles
|
|
