SQL 面试题与答案
Question: Explain UNION, MINUS, UNION ALL and INTERSECT?Answer: INTERSECT - returns all distinct rows selected by both queries. MINUS - returns all distinct rows selected by the first query but not by the second. UNION - returns all distinct rows selected by either query UNION ALL - returns all rows selected by either query, including all duplicates. |
保存以便复习
收藏此条目、标记为困难题，或将其加入复习集合。
这有帮助吗？ 是 否
用户评价最有帮助的内容：