Home »
MCQs »
SQL MCQs »
SQL SET Operators MCQs
MINUS Operator displays the rows which are –
7. MINUS Operator displays the rows which are –
- Detected in the second query, absent in the first query, and there are no duplications.
- Detected in the first query, absent in the second query, and there are no duplications.
- Detected in the first query, absent in the second query, and there are duplications.
- Detected in the second query, absent in the first query, and there are duplications.
Answer: B) Detected in the first query, absent in the second query, and there are no duplications
Explanation:
Detected in the first query, absent in the second query, and there are no duplications.