0 votes
in Sql by
Define UNION, MINUS, UNION ALL, INTERSECT?

1 Answer

0 votes
by

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.

INTERSECT – returns all distinct rows selected by both queries.

Related questions

0 votes
asked Nov 15, 2020 in Data Handling by rajeshsharma
0 votes
asked Jan 6 in C Plus Plus by GeorgeBell
...