SQL AND & OR Operators AND OR Example
Example
Have a table
| Name | Age | City |
|---|---|---|
| Bob | 10 | Paris |
| Mat | 20 | Berlin |
| Mary | 24 | Prague |
select Name from table where Age>10 AND City='Prague'
Gives
| Name |
|---|
| Mary |
select Name from table where Age=10 OR City='Prague'
Gives
| Name |
|---|
| Bob |
| Mary |
