查询全表数据为:
Between and
获取某个值在范围内的所以数据
一 当范围只有两端的值时:
select * from students where age between 6 and 12;(查询中包含两边的值)
二 >,<,=的 使用
select * from students where age>=6 and age<=12;
查询全表数据为:
Between and
获取某个值在范围内的所以数据
一 当范围只有两端的值时:
select * from students where age between 6 and 12;(查询中包含两边的值)
二 >,<,=的 使用
select * from students where age>=6 and age<=12;