Q. Which type of JOIN returns only matching rows from both tables?

  • (A) LEFT JOIN
  • (B) RIGHT JOIN
  • (C) FULL JOIN
  • (D) INNER JOIN
💬 Discuss
✅ Correct Answer: (D) INNER JOIN
Explanation: `INNER JOIN` returns rows when there is at least one match in both tables.

Published by Mr. Dubey ⭐ 111.42K Points at 06-Jun-2025 10:33 pm in MySQL

Explanation by: Mr. Dubey
`INNER JOIN` returns rows when there is at least one match in both tables.

💬 Discussion

📊 Question Analytics

👁️
68
Total Visits
📽️
1 y ago
Published
🎖️
Mr. Dubey
Publisher
📈
89%
Success Rate