SQL BETWEEN() 函数：范围、用法及示例

"between()" \u51fd\u6570\u7684\u8303\u56f4\u662f\u6307\u5728\u7ed9\u5b9a\u7684\u4e24\u4e2a\u503c\u4e4b\u95f4\uff0c\u5305\u62ec\u8fd9\u4e24\u4e2a\u503c\u5728\u5185\u7684\u6240\u6709\u503c\u3002\n\n\u4f8b\u5982\uff0c\u5982\u679c\u7ed9\u5b9a\u7684\u4e24\u4e2a\u503c\u4e3a 1 \u548c 5\uff0c\u5219 "between(1, 5)" \u7684\u8303\u56f4\u4e3a 1\u3001 2\u3001 3\u3001 4 \u548c 5\u3002\n\n\u5728 SQL \u67e5\u8be2\u4e2d\uff0c"between()" \u51fd\u6570\u5e38\u5e38\u7528\u4e8e\u7b5b\u9009\u51fa\u4f4d\u4e8e\u6307\u5b9a\u8303\u56f4\u5185\u7684\u6570\u636e\u3002\u4f8b\u5982\uff0c\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u67e5\u8be2\u8bed\u53e5\u6765\u83b7\u53d6\u5e74\u9f84\u5728 18 \u5230 25 \u4e4b\u95f4\u7684\u7528\u6237\u6570\u636e\uff1a\n\n"SELECT * FROM users WHERE age BETWEEN 18 AND 25;"\n\n\u8fd9\u5c06\u8fd4\u56de\u6240\u6709\u5e74\u9f84\u5728 18 \u5230 25 \u4e4b\u95f4\u7684\u7528\u6237\u6570\u636e\u3002