Question

what is the difference b/w intersect and abilities​

Answer 1

Answer:

Hi buddy

Explanation:

What is the difference between minus and intersect?

1. Intersect Set operator is used to fetch the common records from 2 different tables . 1. Minus Operator is used to fetch the records from first table which eliminates common records.

Answer 2

Answer:

EXCEPT returns distinct rows from the left input query that aren't output by the right input query. INTERSECT returns distinct rows that are output by both the left and right input queries operator.

Hope it will be helpful :)