And
The AND operator can be used in SQL for getting all rows that satisfy all of the conditions that are separated by AND. That means that we can have more than one condition on which we should do the filtering. Imagine we want to get all customers living in the USA that are male. In such a case, we’d write the following query:
TEXT/X-SQL
1SELECT *
2FROM Person
3WHERE Country == ‘USA’ AND Sex == Male;This is the resulting table after running the query written above:
