IN和BETWEEN
课程:SQL · 编程练习
SQL编程练习 - IN和BETWEEN
练习内容
-- 查询指定城市的用户\nSELECT * FROM users\nWHERE city IN ('北京', '上海', '深圳');\n\n-- 查询年龄在20到30之间的用户\nSELECT * FROM users\nWHERE age BETWEEN 20 AND 30;\n\n-- 查询特定状态的订单\nSELECT * FROM orders\nWHERE status IN ('p