Between
The BETWEEN operator is used to filter out only rows belonging to a specific range. These values may be strings, numbers, or dates. When using the between operator, we specify the beginning and ending values and these values are also included in the results (the operator is inclusive).
Let us write a query that would get all information about the orders that were made in 2021:
TEXT/X-SQL
1SELECT *
2FROM Person
3WHERE DateOfOrder BETWEEN ‘2021-01-01’ AND ‘2021-12-31’After running the query, we get the following table:
