题解 | #查找某个年龄段的用户信息#
查找某个年龄段的用户信息
http://www.nowcoder.com/practice/be54223075cc43ceb20e4ce8a8e3e340
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
