Q. The keyword used with UNION that does not retain duplicate rows is ________

  • (A) DISTINCT
  • (B) STRICT
  • (C) NARROW
  • (D) ALL
💬 Discuss
✅ Correct Answer: (A) DISTINCT
Explanation: The keyword ‘DISTINCT’ used along with ‘UNION’ is synonymous with just the ‘UNION’ statement. It produces only the distinct rows from the combination of the two tables in the SELECT query.

Published by Nitin Gupta ⭐ 1.72K Points at 16-Sep-2022 09:31 am in MySQL

Explanation by: Nitin Gupta
The keyword ‘DISTINCT’ used along with ‘UNION’ is synonymous with just the ‘UNION’ statement. It produces only the distinct rows from the combination of the two tables in the SELECT query.

💬 Discussion

📊 Question Analytics

👁️
282
Total Visits
📽️
4 y ago
Published
🎖️
Nitin Gupta
Publisher
📈
80%
Success Rate