1.UNION ALL SELECT SUM(one) ,two FROM (SELECT 1 one, 3 two FROM dual UNION ALL SELECT 3, 5 FROM dual UNION ALL SELECT 4, 3 FROM dual) GROUP BY two
PL/SQL積累
最新推荐文章于 2023-12-21 17:15:20 发布
1.UNION ALL SELECT SUM(one) ,two FROM (SELECT 1 one, 3 two FROM dual UNION ALL SELECT 3, 5 FROM dual UNION ALL SELECT 4, 3 FROM dual) GROUP BY two