题解 | SQL8 查找某个年龄段的用户信息
这个也是带有过滤条件的查询数据。
有两种写法： 一种是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;
查看10道真题和解析