软件测试论坛 › [测试积点任务] › 如何使用 BETWEEN 关键字筛选某个范围内的值？

测试积点老人 发表于 2024-10-18 09:48:38

如何使用 BETWEEN 关键字筛选某个范围内的值？

回复可见
**** Hidden Message *****

开心的大黄瓜 发表于 2024-10-19 11:12:40

select * from test where id between 2 and 3;

你好浮戈 发表于 2024-10-21 09:22:40

BETWEEN关键字后面跟上要筛选的字段名,然后是要筛选的范围,格式为’值1 AND 值2’

海海豚 发表于 2024-10-21 09:46:57

select * from test where id between 2 and 3;

litingting0214 发表于 2024-10-21 10:10:01

select * from test where id between 2 and 3

oliver.tang 发表于 2024-10-21 10:14:12

between …… and

jingzizx 发表于 2024-10-21 10:57:48

between XX and XX

查看完整版本: 如何使用 BETWEEN 关键字筛选某个范围内的值？