SQL 2023 · Querying
Match a list or a range
Use IN for a list of values and BETWEEN for an inclusive range.
SELECT * FROM orders WHERE status IN ('paid', 'shipped') AND total BETWEEN 50 AND 200;
Official SQL 2023 documentation
SQL 2023 · Querying
Use IN for a list of values and BETWEEN for an inclusive range.
SELECT * FROM orders WHERE status IN ('paid', 'shipped') AND total BETWEEN 50 AND 200;
Official SQL 2023 documentation
Was this page helpful?