题解 | #查找某个年龄段的用户信息#

SELECT device_id, gender, age FROM user_profile WHERE age>=20 and age<=23

两种写法，一种使用between...and，格式如下： SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2; 另一种使用...and...，格式如下： SELECT column_name(s) FROM table_name WHERE column_name>=value1 AND column_name <= value2