这个也是带有过滤条件的查询数据。

有两种写法： 一种是age between ... and ... 另一种是age >= 20 and age <= 23

两种写法均可。

select device_id, gender, age from user_profile where age between 20 and 23;

select device_id, gender, age from user_profile where age >= 20 and age <= 23;