Informatics Practices
How is INTERSECT different from MINUS operation ?
SQL Joins & Grouping
1 Like
Answer
In SQL, the INTERSECT operator returns rows common to two tables, while the MINUS (EXCEPT) operator retrieves unique rows from the first table that are not in the second table.
Answered By
2 Likes
Related Questions
What set operations can you perform through SQL ?
How is UNION different from UNION ALL ?
A …………… is a query that retrieves rows from more than one table or view:
- Start
- End
- Join
- All of these
A condition given in a Join query is referred to as …………… .
- Join in SQL
- Join condition
- Join in SQL & Condition
- None of these