UNION联合查询
课程:SQL · 编程练习
SQL编程练习 - UNION联合查询
练习内容
-- 合并当前订单和历史订单\nSELECT order_id, user_id, amount, status, created_at\nFROM current_orders\nWHERE status = 'active'\nUNION\nSELECT order_id, user_id, amount, status, created_at\nFROM archived_orders\nW
课程:SQL · 编程练习
SQL编程练习 - UNION联合查询
-- 合并当前订单和历史订单\nSELECT order_id, user_id, amount, status, created_at\nFROM current_orders\nWHERE status = 'active'\nUNION\nSELECT order_id, user_id, amount, status, created_at\nFROM archived_orders\nW