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