The BETWEEN operator is used in a WHERE clause to select a range of data between two values.
SQL BETWEEN Syntax
SELECT column_name (s) FROM table_name
WHERE coulmn_name BETWEEN value1 AND value2
SQL BETWEEN Operator Example
SELECT * FROM Employee
WHERE Age BETWEEN 25 AND 35
SQL BETWEEN Syntax
SELECT column_name (s) FROM table_name
WHERE coulmn_name BETWEEN value1 AND value2
SQL BETWEEN Operator Example
SELECT * FROM Employee
WHERE Age BETWEEN 25 AND 35
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.