Title Untitled document - 2024-08-30T212113.271.pdf ✅

Experiment No 10: Use Set operators to perform different operations Practical related questions (Provide space for answers) 1. Explain the need for set operators in SQL Answer: Set operators in SQL are essential for combining and comparing results from multiple SELECT queries. They allow you to perform operations like union, intersection, and difference on datasets, helping you analyze and manipulate data across different tables or queries. The main set operators include: ● UNION: Combines results from two queries, removing duplicates. ● UNION ALL: Combines results from two queries, including duplicates. ● INTERSECT: Returns only the common records between two queries. ● EXCEPT (or MINUS): Returns records from the first query that are not in the second. These operators are useful for data comparison, filtering, and aggregation across different datasets. 2. Describe various set operators in SQL Answer: UNION: ● Combines the results of two queries. ● Removes duplicate rows, returning only distinct records. UNION ALL: ● Combines the results of two queries. ● Includes all rows, including duplicates. INTERSECT: ● Returns only the common rows between two queries. ● Only records present in both result sets are included. EXCEPT (or MINUS): ● Returns rows from the first query that are not in the second. Practicalkida.com