sql语句bewwten

谁给我一个bewwten的例子？

谢谢

是between吧？

例如（在表cj[成绩]中找到wl[物理]在60到100之间的记录）：

select * from cj where wl between 60 and 100

语法 SELECt column_name(s) FROM table_name WHERe column_name BETWEEN value1 AND value2 例子 select * from aaa where scr between 60 and 100

bewwten???

查询满足给定两个条件中的记录

SELECt 字段名

FROM 表名

WHERe 字段名 BETWEEN 条件一 AND 条件二

select * from A where time between '1999-10-1' and '2001-12-1';